{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "1ac1accd",
   "metadata": {},
   "source": [
    "# dataframe运算"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "dd3558b4",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "ea7b26ea",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv(\"./database/2023-07能耗费用明细22.csv\", encoding=\"gb18030\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a5646e0b",
   "metadata": {},
   "outputs": [],
   "source": [
    "simple = data.iloc[:5, :7]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "34efad95",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    21\n",
       "1    35\n",
       "2    35\n",
       "3    33\n",
       "4    34\n",
       "Name: 租赁天数, dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple['租赁天数'].add(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "9666f766",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    21\n",
       "1    35\n",
       "2    35\n",
       "3    33\n",
       "4    34\n",
       "Name: 租赁天数, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple['租赁天数'] + 20"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "ecbb2b41",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wy企业1333345</td>\n",
       "      <td>8</td>\n",
       "      <td>2023/5/1</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.80%、21.60%、2.16%</td>\n",
       "      <td>0.10%、2.55%、1.02%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/1</td>\n",
       "      <td>13</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wy企业4</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          企业名称  租赁面积/㎡       开始日期       截止日期  租赁天数               总【占比】  \\\n",
       "0  wy企业1333345       8   2023/5/1   2023/7/1     1  0.80%、21.60%、2.16%   \n",
       "1        wy企业3       1  2023/7/17  2024/7/31    15     100.00%、100.00%   \n",
       "2        wy企业3       1  2023/7/17  2024/7/31    15     100.00%、100.00%   \n",
       "3        wy企业3       1  2023/7/19   2024/7/1    13     100.00%、100.00%   \n",
       "4        wy企业4       1  2023/7/18   2024/8/1    14       0.13%、100.00%   \n",
       "\n",
       "            办公用房【占比】  \n",
       "0  0.10%、2.55%、1.02%  \n",
       "1    100.00%、100.00%  \n",
       "2    100.00%、100.00%  \n",
       "3    100.00%、100.00%  \n",
       "4      0.13%、100.00%  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "5b484284",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wy企业4</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    企业名称  租赁面积/㎡       开始日期       截止日期  租赁天数            总【占比】         办公用房【占比】\n",
       "1  wy企业3       1  2023/7/17  2024/7/31    15  100.00%、100.00%  100.00%、100.00%\n",
       "2  wy企业3       1  2023/7/17  2024/7/31    15  100.00%、100.00%  100.00%、100.00%\n",
       "4  wy企业4       1  2023/7/18   2024/8/1    14    0.13%、100.00%    0.13%、100.00%"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple[simple[\"租赁天数\"]>13]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "f88bcf33",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    False\n",
       "1     True\n",
       "2     True\n",
       "3    False\n",
       "4     True\n",
       "Name: 租赁天数, dtype: bool"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple[\"租赁天数\"]>13"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "f355207a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wy企业4</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    企业名称  租赁面积/㎡       开始日期       截止日期  租赁天数            总【占比】         办公用房【占比】\n",
       "1  wy企业3       1  2023/7/17  2024/7/31    15  100.00%、100.00%  100.00%、100.00%\n",
       "2  wy企业3       1  2023/7/17  2024/7/31    15  100.00%、100.00%  100.00%、100.00%\n",
       "4  wy企业4       1  2023/7/18   2024/8/1    14    0.13%、100.00%    0.13%、100.00%"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple.query(\"租赁天数 > 13\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d601ba07",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/1</td>\n",
       "      <td>13</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    企业名称  租赁面积/㎡       开始日期       截止日期  租赁天数            总【占比】         办公用房【占比】\n",
       "1  wy企业3       1  2023/7/17  2024/7/31    15  100.00%、100.00%  100.00%、100.00%\n",
       "2  wy企业3       1  2023/7/17  2024/7/31    15  100.00%、100.00%  100.00%、100.00%\n",
       "3  wy企业3       1  2023/7/19   2024/7/1    13  100.00%、100.00%  100.00%、100.00%"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple[simple[\"租赁天数\"].isin([15, 13])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "ea1cd585",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wy企业1333345</td>\n",
       "      <td>8</td>\n",
       "      <td>2023/5/1</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.80%、21.60%、2.16%</td>\n",
       "      <td>0.10%、2.55%、1.02%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/1</td>\n",
       "      <td>13</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wy企业4</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          企业名称  租赁面积/㎡       开始日期       截止日期  租赁天数               总【占比】  \\\n",
       "0  wy企业1333345       8   2023/5/1   2023/7/1     1  0.80%、21.60%、2.16%   \n",
       "1        wy企业3       1  2023/7/17  2024/7/31    15     100.00%、100.00%   \n",
       "2        wy企业3       1  2023/7/17  2024/7/31    15     100.00%、100.00%   \n",
       "3        wy企业3       1  2023/7/19   2024/7/1    13     100.00%、100.00%   \n",
       "4        wy企业4       1  2023/7/18   2024/8/1    14       0.13%、100.00%   \n",
       "\n",
       "            办公用房【占比】  \n",
       "0  0.10%、2.55%、1.02%  \n",
       "1    100.00%、100.00%  \n",
       "2    100.00%、100.00%  \n",
       "3    100.00%、100.00%  \n",
       "4      0.13%、100.00%  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "ac4cab46",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>办公【电费】【含税】</th>\n",
       "      <th>测试机房【电费】【含税】</th>\n",
       "      <th>【水费】【含税】</th>\n",
       "      <th>餐厅【燃气费】【含税】</th>\n",
       "      <th>单位不含税合计</th>\n",
       "      <th>单位税金合计</th>\n",
       "      <th>单位含税合计</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>138.000000</td>\n",
       "      <td>52.769231</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.692308</td>\n",
       "      <td>19.655000</td>\n",
       "      <td>7.692308</td>\n",
       "      <td>31.896154</td>\n",
       "      <td>3.142692</td>\n",
       "      <td>35.039615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>168.838147</td>\n",
       "      <td>172.402392</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39.223227</td>\n",
       "      <td>60.313543</td>\n",
       "      <td>39.223227</td>\n",
       "      <td>110.705538</td>\n",
       "      <td>11.236984</td>\n",
       "      <td>121.930019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>9.000000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>61.500000</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>222.000000</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>566.000000</td>\n",
       "      <td>897.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>200.000000</td>\n",
       "      <td>249.580000</td>\n",
       "      <td>200.000000</td>\n",
       "      <td>524.020000</td>\n",
       "      <td>54.240000</td>\n",
       "      <td>578.260000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           租赁面积/㎡        租赁天数  办公【电费】【含税】  测试机房【电费】【含税】    【水费】【含税】  \\\n",
       "count   26.000000   26.000000        26.0     26.000000   26.000000   \n",
       "mean   138.000000   52.769231         0.0      7.692308   19.655000   \n",
       "std    168.838147  172.402392         0.0     39.223227   60.313543   \n",
       "min      1.000000    1.000000         0.0      0.000000    0.000000   \n",
       "25%      9.000000   14.000000         0.0      0.000000    0.000000   \n",
       "50%     61.500000   15.000000         0.0      0.000000    0.000000   \n",
       "75%    222.000000   31.000000         0.0      0.000000    0.000000   \n",
       "max    566.000000  897.000000         0.0    200.000000  249.580000   \n",
       "\n",
       "       餐厅【燃气费】【含税】     单位不含税合计     单位税金合计      单位含税合计  \n",
       "count    26.000000   26.000000  26.000000   26.000000  \n",
       "mean      7.692308   31.896154   3.142692   35.039615  \n",
       "std      39.223227  110.705538  11.236984  121.930019  \n",
       "min       0.000000    0.000000   0.000000    0.000000  \n",
       "25%       0.000000    0.000000   0.000000    0.000000  \n",
       "50%       0.000000    0.000000   0.000000    0.000000  \n",
       "75%       0.000000    0.000000   0.000000    0.000000  \n",
       "max     200.000000  524.020000  54.240000  578.260000  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "867d1077",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple['租赁天数'].idxmax()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "f0ae7720",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple['租赁天数'].idxmin()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "e2a274ed",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wy企业1333345</td>\n",
       "      <td>8</td>\n",
       "      <td>2023/5/1</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.80%、21.60%、2.16%</td>\n",
       "      <td>0.10%、2.55%、1.02%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业1333345wy企业3</td>\n",
       "      <td>9</td>\n",
       "      <td>2023/5/12023/7/17</td>\n",
       "      <td>2023/7/12024/7/31</td>\n",
       "      <td>16</td>\n",
       "      <td>0.80%、21.60%、2.16%100.00%、100.00%</td>\n",
       "      <td>0.10%、2.55%、1.02%100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业1333345wy企业3wy企业3</td>\n",
       "      <td>10</td>\n",
       "      <td>2023/5/12023/7/172023/7/17</td>\n",
       "      <td>2023/7/12024/7/312024/7/31</td>\n",
       "      <td>31</td>\n",
       "      <td>0.80%、21.60%、2.16%100.00%、100.00%100.00%、100.00%</td>\n",
       "      <td>0.10%、2.55%、1.02%100.00%、100.00%100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wy企业1333345wy企业3wy企业3wy企业3</td>\n",
       "      <td>11</td>\n",
       "      <td>2023/5/12023/7/172023/7/172023/7/19</td>\n",
       "      <td>2023/7/12024/7/312024/7/312024/7/1</td>\n",
       "      <td>44</td>\n",
       "      <td>0.80%、21.60%、2.16%100.00%、100.00%100.00%、100.0...</td>\n",
       "      <td>0.10%、2.55%、1.02%100.00%、100.00%100.00%、100.00...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wy企业1333345wy企业3wy企业3wy企业3wy企业4</td>\n",
       "      <td>12</td>\n",
       "      <td>2023/5/12023/7/172023/7/172023/7/192023/7/18</td>\n",
       "      <td>2023/7/12024/7/312024/7/312024/7/12024/8/1</td>\n",
       "      <td>58</td>\n",
       "      <td>0.80%、21.60%、2.16%100.00%、100.00%100.00%、100.0...</td>\n",
       "      <td>0.10%、2.55%、1.02%100.00%、100.00%100.00%、100.00...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              企业名称  租赁面积/㎡  \\\n",
       "0                      wy企业1333345       8   \n",
       "1                 wy企业1333345wy企业3       9   \n",
       "2            wy企业1333345wy企业3wy企业3      10   \n",
       "3       wy企业1333345wy企业3wy企业3wy企业3      11   \n",
       "4  wy企业1333345wy企业3wy企业3wy企业3wy企业4      12   \n",
       "\n",
       "                                           开始日期  \\\n",
       "0                                      2023/5/1   \n",
       "1                             2023/5/12023/7/17   \n",
       "2                    2023/5/12023/7/172023/7/17   \n",
       "3           2023/5/12023/7/172023/7/172023/7/19   \n",
       "4  2023/5/12023/7/172023/7/172023/7/192023/7/18   \n",
       "\n",
       "                                         截止日期  租赁天数  \\\n",
       "0                                    2023/7/1     1   \n",
       "1                           2023/7/12024/7/31    16   \n",
       "2                  2023/7/12024/7/312024/7/31    31   \n",
       "3          2023/7/12024/7/312024/7/312024/7/1    44   \n",
       "4  2023/7/12024/7/312024/7/312024/7/12024/8/1    58   \n",
       "\n",
       "                                               总【占比】  \\\n",
       "0                                 0.80%、21.60%、2.16%   \n",
       "1                  0.80%、21.60%、2.16%100.00%、100.00%   \n",
       "2   0.80%、21.60%、2.16%100.00%、100.00%100.00%、100.00%   \n",
       "3  0.80%、21.60%、2.16%100.00%、100.00%100.00%、100.0...   \n",
       "4  0.80%、21.60%、2.16%100.00%、100.00%100.00%、100.0...   \n",
       "\n",
       "                                            办公用房【占比】  \n",
       "0                                  0.10%、2.55%、1.02%  \n",
       "1                   0.10%、2.55%、1.02%100.00%、100.00%  \n",
       "2    0.10%、2.55%、1.02%100.00%、100.00%100.00%、100.00%  \n",
       "3  0.10%、2.55%、1.02%100.00%、100.00%100.00%、100.00...  \n",
       "4  0.10%、2.55%、1.02%100.00%、100.00%100.00%、100.00...  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple.cumsum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "25f0f839",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Axes: ylabel='Frequency'>"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjQAAAGbCAYAAADTKQqlAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/bCgiHAAAACXBIWXMAAA9hAAAPYQGoP6dpAAA3G0lEQVR4nO3deVxVdf7H8TebCMqm0CgjCqNpNmRopKPGiNnPynXSxsKh1Ew0KR01M6ZpXFp0tKH85TJpmSNj45I2zuDStLiUW6ZiWJobIjSoSHBxYb/n94cP7k8SBPFyL0dfz8fjPB58D9/vvZ9zSXj3Pd9zjothGIYAAABMzNXZBQAAANwoAg0AADA9Ag0AADA9Ag0AADA9Ag0AADA9Ag0AADA9Ag0AADA9Ag0AADA9d2cX4AhWq1X//e9/5ePjIxcXF2eXAwAAasAwDJ0/f17BwcFydb32HMwtEWj++9//KiQkxNllAACAWsjIyFCLFi2u2eeWCDQ+Pj6SLn8gvr6+Tq4GAADURH5+vkJCQmx/x6/llgg05aeZfH19CTQAAJhMTZaLsCgYAACYHoEGAACYHoEGAACY3i2xhgYAYB6GYai0tFRlZWXOLgV1zM3NTe7u7na5pQqBBgBQbxQXFysrK0uXLl1ydilwEG9vbzVv3lwNGjS4odch0AAA6gWr1aq0tDS5ubkpODhYDRo04GaoNzHDMFRcXKzs7GylpaXp9ttvr/bmeddCoAEA1AvFxcWyWq0KCQmRt7e3s8uBA3h5ecnDw0Pp6ekqLi5Ww4YNa/1aLAoGANQrN/J/6TAfe/28maEBAMBODMPQ7t27lZ2drf79+9dozPjx43XPPfcoNjZWpaWlunjxos6dO6fDhw8rNTVVnTt31gMPPCDp8iyWpBqtN7FarSosLLT7bJfVaq2XoZNAAwDADcjOztbChQuVkpKinTt3ytPTU/3791eTJk3Us2dPBQcHS7ocBDIyMnTx4kVbyDhx4oSWL1+uKVOmqGvXriooKNDFixdVWlqq7t27KzAwUN99950t0MyfP19vvPGGPDw8KtTwww8/qEmTJvLy8rLts1qt+tnPfqY9e/ZIuhy20tLStHXrVv3tb3/TwoUL9cEHH+jtt9+Wv7+/JOnChQvq06ePli1bVuXx/u53v9MHH3xQo/VN6enpWrZsmfz8/DRu3Liaf6i14NRAs23bNvXo0UObN29WdHT0NfsmJSXpD3/4g/Ly8jR8+HC99dZbcnNzc0yhAABUwc/PTwcPHtR9992nAwcOaOXKlYqMjNS+ffvUtm1bHTx4UJJ07tw5BQUFVVgnMnnyZI0YMULBwcHavXu3JGnp0qX68ssv9e677171XhMmTNCECROu2t+kSRNt3rxZd955Z6U1pqamymKxKDs7WytXrtTnn3+ukpISNWzYUL///e81bdo023vv2LGjymP997//rW7dutV4sXZ2drYeffRRPfnkkzdvoCkpKdHYsWNr1PfIkSOKi4vTihUr1K5dO/Xt21cdOnTQqFGj6rhKAICzhb643qHvd3JW3+vq36BBA61atUqSKsxsVHVapnz/rFmztHbtWk2dOlUlJSVXzbqUK78ayNPTs9Lvnzt3ThcuXFC7du2qrPGuu+6SJG3ZssVWg6enp9zc3FRSUlJpfZXVsXjxYq1evfqq/du3b1ejRo0UERGhtWvXymKxaPjw4YqMjNQHH3yg119/XaWlpXJ3r7vY4bRA8+abb+q2225TZmZmtX2XL1+u+++/XwMHDpQkxcfHKykpiUADAHA6wzBUWFhom3mxWq22++gUFhbq66+/liRZLBbbmEOHDunDDz/U+PHjJUlDhgzR0aNHJUl5eXm6dOmSdu3aZesfGxurF198UdLl0DR79mzb94qKimS1WnX33XdXqKt79+565513bHVceVajuLhYhmFc13GuWbNG/fr1swWr48eP6+GHH1b37t3Vtm1b/eUvf9G4cePUoEED/fWvf1VAQIDc3Nw0bdo0+fj46Isvvrj5Ak1mZqZmzZql7du3q2vXrtX23759u3r27Glrd+nSRVOmTJFhGJVOexUVFamoqMjWzs/Pt0/hAAD8RGZmpu699155eHgoMzNTAwYMUFBQkJKSknT27Fnb6ZwrZ0Lat2+vr7/+WvPmzdO5c+f00Ucf2b53rVNO0uVgFBkZqaVLl+rFF19UYGCgnn/+eR08eFCxsbFKSUnRihUr9Pe//902ZtKkSVq3bp0uXbqkgoIChYWF6amnnlKjRo1qdIxWq1XLli3TmjVrbPtat26tzp07KzIyUvHx8UpLS5O3t7eef/55lZWVKT09Xb///e81YMCA6/k4a80pgWb8+PEaPXq02rdvX6P+p0+fVmBgoK3dtGlTlZaWKicnp8L+cjNnztT06dPtVm91HD0dag/XO6UKAKhcSEiITp8+reTkZPXv31/JycmKjIxUSkqKWrZsqeTkZEn/v4bmSsXFxSoqKtLBgwc1YMAA+fr6qqCgQCUlJYqIiJDValV4eLg++OAD25iqTk391JWzIfPnz9f8+fM1dOhQ/fjjj9q4caNcXFw0Y8aMq8b99BSUJK1YsUKDBw++6r0bN26sn/3sZ5IkHx8ftWrVSpLk6+vr8EdXODzQbNq0SXv37lVSUtJ1jbtyaqz866oWJSUkJGjixIm2dn5+vkJCQmpRLQAANbNo0SJJl2dYDh8+rPDw8GrH9OnTR4WFhQoPD9eJEydq9b5/+ctftHTpUhUVFV1zxuXw4cNav369WrdurS5duujTTz9VUVGR5s+fr6VLl0q6fJXTQw89VGFcWVmZVqxYUWEWqTIuLi62v8vOuMOzwwPNypUrlZWVZbuMzWKxqF+/flq0aJGGDh1a6ZjmzZsrOzvb1s7JyZGHh4eaNGlSaX9PT88qF08BAGBvx44d0+7du3X77bcrODhYkyZN0po1a3TkyBGFhoZKunza5qe8vLzUoUMHtW3bttLX/eGHHzR37lw9+eSTVb73pEmTKpxyqkxZWZlGjRqluLg4paam6rbbbtO0adOUmJioV1555Zr3lUlKSlJMTEy9v7LY4YFmzpw5mjp1qq3doUMHLVq0SP369atyTFRUVIXLyHbt2qXu3bvzjA8AgNOVlpYqLi5OY8aM0bp169S7d2/l5uaquLi40su2r9SgQQMFBwfb+ixcuFDNmjXTI488IkkaPnx4tTfRq8kMzYQJE9SkSRP17dtXqampmjt3rtzc3GS1WtWjRw8999xz6tatm0aOHKnVq1fL19dX0uXTTx999FG1szP1gcNv9RcYGKjQ0FDb5urqqmbNmqlx48bKy8ur9Jzb0KFDtWXLFq1bt06HDx/WggULqkyhAAA40oYNG3T8+HFNnjzZtm/OnDlVnkW40pXrVQoKCvTKK6/IYrHYrpLy8/Or9n/eJ02apIMHD14zdAwfPlyLFy+2tQMCAuTr66vExETl5eXpoYceUosWLRQYGKhhw4bZ+i1ZskTDhg2rcgbnwoULtqu3CgsLdf78eUmXw9u5c+eqOXr7qld3Cg4ICND+/fsVERFRYX+bNm20ePFixcfH265tHzFihHOKBADgCgMGDNAdd9yhxo0byzAMGYahkpKSSk8xSZdndFxcXGxPFf/yyy91/PhxjR07Vl27dlVMTIzat2+vli1bKiYmRr17964w3mq1at26dQoPD9eZM2fk7u5um6HJzMxUeHi4LBZLhb+lnTp1kiR98803trqWL1+uOXPmaPfu3bYZmXfeeUeRkZF68803NXbsWG3cuLHKoJSdna077rhD2dnZOnr0qG15SEZGhtzd3eXu7q6zZ8/qtttuu9GPuEacHmjy8vJsX1/rmvjY2FhmZQAA9VL5GpjCwkIVFhbqvffe09SpU9WwYUPbGhpJatWqlVq2bKnVq1eruLhYf/7zn5WWlqaCggJNmDBB48aNk5ubmw4fPqwNGzZo7ty5Gj9+vLZu3aouXbpIujyrM3DgQNtC3sqsWLFC77///lX7LRaLCgsLVVRUpGXLlumf//xnhfoaN26sf/zjH9q5c6fKysr02muvVTlDFBQUpD/+8Y+29ksvvWT7+sr9juJiXO+ddUwoPz9ffn5+slgsthRqT1y2DQA3rrCwUGlpaQoLC6vweICbVXmouOeee9SxY8cqg0NKSspVZy5uJtf6uV/P32+nz9AAAHAr8vT0rNEd72/mMGNP9e/53wAAANeJQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPy7YBALATwzC0e/duZWdnq3///jUaM378eN1zzz2KjY1VaWmpLl68qHPnzunw4cNKTU1V586d9cADD9R53WZ/PiKBBgCAG5Cdna2FCxcqJSVFO3fulKenp/r3768mTZqoZ8+eCg4OlnT5kQUZGRm6ePGivL29JUknTpzQ8uXLNWXKFHXt2lUFBQW6ePGiSktL1b17dwUGBuq77767KtDk5ubK3d290hBiGIaKi4vl4+NT4cGWb731ln71q19p48aNKiwsVFRUlHbv3q1XXnlF8fHxCgoK0vTp0+vwk6pbBBoAQP02zc/B72e5ru5+fn46ePCg7rvvPh04cEArV65UZGSk9u3bV+nTtq+8G+7kyZM1YsQIBQcHa/fu3ZKkpUuX6ssvv9S7775b5XvefffdysvLsz00Mj8/X97e3nJ3d5dhGCooKNDGjRvVq1cv25jo6GgdPHhQnp6ekqTU1FQ9+uijkqSvvvpKkydP1rFjxyRJbm5uCgsLu67PwdkINAAA3IAGDRpo1apVkqRly5bZ9lf1hOry/bNmzdLatWs1depUlZSUyMPDo9L+5TMu5UFEkk6dOlWhT4sWLfT3v/9d0dHRlb7Gjh071KdPH3l7eys3N1eenp5q3LixZs+erU8//VQnTpzQ6tWr9d5772nPnj0aOXKk3njjjRp/BvUBgQYAgBtgGIYKCwttMy9Wq1WXLl2SdPk5RV9//bWkyw+GLHfo0CF9+OGHGj9+vCRpyJAhOnr0qKTLD22+dOmSdu3aZesfGxurF198sdY1duvWTbm5uXr66af18ccf66mnnlJOTo5ee+01vfvuu3r00Ue1aNEi7d27VxMnTjRdmJEINAAA3JDMzEzde++98vDwUGZmpgYMGKCgoCAlJSXp7NmzmjZtmqTLT8ku1759e3399deaN2+ezp07p48++sj2vepOOV26dEkeHh5VzuiUKyoqkqurqzw8PJSenq5Ro0bJarXqiSeeUHFxsSRpypQp+vTTT22npvLy8hQUFHQjH4fTEGgAALgBISEhOn36tJKTk9W/f38lJycrMjJSKSkpatmypZKTkyX9/xqaKxUXF6uoqEgHDx7UgAED5Ovrq4KCApWUlCgiIkJWq1Xh4eH64IMPbGO6deumb775psIprbKyMvXq1avCIuGysjItXLhQY8aMUWBgoMLDwzVt2jRt2rRJPXv2VElJib766isdOnRI3333nSTpv//9r5o1a1aXH1edIdAAAGAHixYtknR5huXw4cMKDw+vdkyfPn1UWFio8PBwnThxokbvs3fvXrm5udna27dvV1RUlAYNGqTVq1fb9lutVtvXbm5umj17tnbv3q3Jkyfr+PHjcnd3129+8xsNGDBA/fr105EjR/Tdd9/p9ttvr+kh1yvcWA8AgBt07Ngx7d69W7fffruCg4M1adIkXbhwQUeOHFFoaKhCQ0PVqVOnq8Z5eXmpc+fOCg8Pr3QLCAiosNBYUoUwI0nz5s1TXFyc9u3bpz179tj2u7q62mZxRowYobCwMP3P//yPCgoK1KZNGzVo0ECfffaZXF1d9cADD2jFihXavXu3OnbsWAefUN1jhgYAgBtQWlqquLg4jRkzRuvWrVPv3r2Vm5ur4uLiSi/bvlKDBg0UHBxs67Nw4UI1a9ZMjzzyiCRp+PDhFe4l81ObNm3SunXr9N1336lz5856/PHHtXfvXvn7+1fo949//EP5+fm6++679fXXX8vV1VXh4eGKioqSJA0aNEjdu3eXi4uLfvWrX9nro3EoZmgAALgBGzZs0PHjxzV58mTbvjlz5qhJkybVjr1yoXBBQYFeeeUVWSwW21VSfn5+Vd7Bd/369frtb3+rxMREhYaGasSIEYqMjFR0dHSlp68OHTqkNm3aqFevXurTp486duxoWxzcsmVLNWrUSPfff/81A1R9RqABAOAGDBgwQJ988okaN24swzBkGIZKSkoqrGG5UmlpqcrKyiRJwcHB+vLLL3X8+HH95je/UdeuXRUTE6Pw8HBFR0frzjvvVO/evSuMP336tOLi4vToo4/qjTfe0JgxYyRJLi4u+tvf/qbQ0FB17NhREydO1Pfff28b16VLF61evVodO3aUi4uLzp49qyeeeEK5ubl65JFHFBwcrPXr11dYh2MmnHICANRv13nnXmdo27atpMv3nSksLNR7772nqVOnqmHDhgoNDbX1a9WqlVq2bKnVq1eruLhYf/7zn5WWlqaCggJNmDBB48aNk5ubmw4fPqwNGzZo7ty5Gj9+vLZu3aouXbooJydHHTp0UJs2bfTVV1/prrvuqlBHw4YN9dFHH2nevHl69dVX1bVrV7Vr10579uzRe++9pw0bNmj48OF655135OHhoT/+8Y/6xS9+oUcffVQffvih/vOf/2jw4MHauXOnEhMTHfkR3jAXwzAMZxdR1/Lz8+Xn5yeLxSJfX1+7v37oi+vt/pp17eSsvs4uAQAqKCwsVFpamsLCwio8HuBmVVRUpGXLlumee+6xzZpUJiUlRREREbZ2+WdUnYKCAnl5eUmSdu7cqa1bt+qpp57SbbfdZuuzZs0a+fn5VXhW1FdffaWgoCCHPfrgWj/36/n7TaCxAwINANy4Wy3Q4DJ7BRrW0AAAANMj0AAAANMj0AAA6pVbYCUErmCvnzeBBgBQL5Q/bLH8Hiy4NZT/vKt72GZ1uGwbAFAvuLm5yd/fX2fPnpUkeXt7V3nlD8zPMAxdunRJZ8+elb+//1WPdLheBBoAQL1R/qTn8lCDm5+/v79dnvBNoAEA1BsuLi5q3ry5brvttgqPBcDNycPD44ZnZsoRaAAA9Y6bm5vd/tDh1sCiYAAAYHoEGgAAYHpOCTSHDh1S165d1bhxY0VFReno0aPVjnFxcamwXfmwLwAAcGtzSqCJiYnRgAEDdOTIEd1xxx22R59X59ChQ8rNzVVubq6++eabOq4SAACYhcMXBefm5srHx0eTJk1SgwYN9Mgjj2jkyJE1GvuLX/xCDRo0qOMKAQCA2Th8hiYgIEBffPGFGjRooOLiYq1atUodO3asdlzDhg0VGxsrLy8v/frXv9YPP/xQZd+ioiLl5+dX2AAAwM3LqYuCvb29tXHjRs2bN6/avoWFherZs6eOHDkid3d3Pf/881X2nTlzpvz8/GxbSEiIPcsGAAD1jFMDzVdffaVOnTpp3Lhx1fbNyMjQM888o5CQEI0ZM0abN2+usm9CQoIsFotty8jIsGfZAACgnnH4Gprs7GxlZmaqY8eO6tSpk15//XV16tRJFotFfn5+VY5r0aKF7Wt/f/9rnkby9PSUp6enXesGAAD1l8NnaPbv36++ffva2uUPHnN1rbqUBQsWqHfv3rb2qVOnuGwbAADYODzQdO7cWYWFhZo/f74yMzOVmJioqKgo+fj4KD8/v9Jnd/z617/Wtm3blJycrO+//15z587V8OHDHV06AACopxweaPz9/bV27VotWrRI7du315kzZ5SUlCRJ6tChg9avX3/VmPDwcP31r39VfHy8oqKi9MADD2jChAmOLh0AANRTLoZhGM4uoq7l5+fLz89PFotFvr6+dn/90BevDmH13clZfavvBACAE13P32+e5QQAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEyPQAMAAEzPKYHm0KFD6tq1qxo3bqyoqCgdPXq02jEff/yx2rZtq0aNGunxxx/XpUuXHFApAAAwA6cEmpiYGA0YMEBHjhzRHXfcoTFjxlyzf15enoYMGaKJEyfq22+/1cmTJ/Xaa685qFoAAFDfOTzQ5ObmysfHR5MmTVJwcLAeeeQRfffdd9cc89FHH6lFixYaM2aMQkND9cILL+jvf/+7gyoGAAD1nbuj3zAgIEBffPGFJKm4uFirVq1Sx44drzlm+/bt6tatm63dpUsXnTp1ShkZGQoJCbmqf1FRkYqKimzt/Px8O1UPAADqI4cHmit5e3uradOm2rlz5zX7nT59WnfddZet3bRpU0nSmTNnKg00M2fO1PTp0+1bLAAAjjLNz9kVXL9pFqe+vVOvcvrqq6/UqVMnjRs3rtq+hmFc9bWLi0ulfRMSEmSxWGxbRkaGfQoGAAD1ksNnaLKzs5WZmamOHTuqU6dOev3119WpUydZLBb5+VWeSJs3b67s7GxbOycnR5LUrFmzSvt7enrK09PT/sUDAIB6yeEzNPv371ffvn1t7fJZFlfXqkuJiorSjh07bO1du3YpNDRUP//5z+uuUAAAYBoODzSdO3dWYWGh5s+fr8zMTCUmJioqKko+Pj7Kz89XSUnJVWMGDhyorKwsLVy4UCdPntScOXMUGxvr6NIBAEA95fBA4+/vr7Vr12rRokVq3769zpw5o6SkJElShw4dtH79+qvG+Pn5adWqVUpMTNSdd96psLAwJSQkOLp0AABQTznlKqfo6GgdOHDgqv0nT56sckzv3r1rdEdhAABw6+FZTgAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPScEmhOnDihHj16yMfHR9HR0UpPT79m/5MnT8rFxaXCFh0d7ZhiAQBAveeUQBMXF6eWLVvq4MGDatq0qeLj46sd4+HhodzcXNuWnJzsgEoBAIAZuDv6DYuLi/X555/r4MGDatWqlUaOHKmYmJhqxwUFBcnf37/uCwQAAKbj8BmakpISzZ49W2FhYZKknJwceXl5VTvOzc1NvXr1kre3twYOHCiLxVJl36KiIuXn51fYAADAzcvhgaZRo0Z6/vnn5eXlpZKSEs2dO1dPPPFEtePOnDmj+Ph4paam6tixY5o1a1aVfWfOnCk/Pz/bFhISYs9DAAAA9YzTrnIqLS1VTEyM3NzcNGPGjGv2bdGihdLT0zVo0CC1bt1aw4YN0+bNm6vsn5CQIIvFYtsyMjLsXT4AAKhHHL6GRpKsVqsee+wxpaen65NPPqn2lJO7u7uaNWtma/v7+1/zNJKnp6c8PT3tVi8AAKjfnDJD8/LLL+v48eP67LPPFBAQUG3/KVOmaNSoUbb2qVOnFBoaWocVAgAAM3H4DE16eroSExP1+eefyzAM5eXlSZJ8fX2Vn58vHx8fubm5VRgTHR2toUOHavjw4fLy8tL777+vN99809GlAwCAesrhgWbLli0qLCxUt27dKuxPS0tTWFiY9u/fr4iIiArfe/jhh/XCCy9o8ODBcnNz07PPPqshQ4Y4sGoAAFCfuRiGYTi7iLqWn58vPz8/WSwW+fr62v31Q19cb/fXrGsnZ/V1dgkAgKpM83N2BddvWtW3U6mt6/n7Xas1NN26ddPbb7+t06dP16pAAAAAe6pVoHnqqaf08ccfq3Xr1urZs6feeecd5eTk2Ls2AACAGqlVoHn66aeVnJysM2fOaOzYsdq2bZvatm2rhx56SEuXLlVRUZG96wQAAKjSDV22ff78eWVnZysrK0sFBQVyc3PT6tWr1a9fP3vVBwAAUK1aXeX0l7/8RWvWrNG+ffsUHR2t2NhYrVmzRgEBAcrKyrI9pwkAAMARahVoNm7cqOHDh+vf//63mjZtWuF73t7e2rZtm12KAwAAqIlaBZpPP/20yu/5+fmpc+fOtS4IAADgetVqDc358+c1ceJEbd26VZLUp08fjR07VhcuXLBrcQAAADVRq0ATFxenvXv3Kjg4WJI0efJkHT9+XM8995xdiwMAAKiJWp1y2rRpk1JSUtSqVStJUs+ePRUaGqrIyEi7FgcAAFATtZqhCQoK0rffflth36FDh9SkSRO7FAUAAHA9ajVDM336dD322GN68sknFRoaqpMnTyopKUl//etf7V0fAABAtWo1QxMTE6P//Oc/Ki0t1ebNm1VaWqpNmzZp6NCh9q4PAACgWrWaoZGkrl27qmvXrvasBQAAoFZqFWh27typhIQEZWRkyDCMCt87ceKEXQoDAACoqVoFmt/97nfq3r27XnrpJTVo0MDeNQEAAFyXWgWa3Nxcvfrqq7bLtgEAAJypVouCJ06cqOnTp6u0tNTe9QAAAFy3Ws3QnDhxQhs2bFBoaKh+9atfydfX1/a9JUuW2K04AACAmqhVoAkNDdXYsWPtXQsAAECt1CrQTJ061d51AAAA1Fqt1tCcO3dOI0eOVPv27fXDDz9oypQpeuKJJ5SXl2fn8gAAAKpXq0Dz9NNPq7S0VD/88IPKysr01FNPKT8/X3FxcfauDwAAoFq1OuW0efNmpaSk6F//+pckqV27dnr77bd111132bU4AACAmqjVDE2rVq2UkZEhFxcXubi4SLocclq2bGnX4gAAAGqiVjM0s2fP1rBhw3Tp0iW9+OKLOn36tHbs2KG1a9fauz4AAIBq1SrQPPTQQ/r000+1cuVKZWZm6pe//KUWLVqk1q1b27s+AACAatX6adutW7fWH/7wB3vWAgAAUCu1CjRhYWG2tTM/xdO2AQCAo9Uq0CxdutT29cWLF7Vnzx4tXrxY06dPt1ddAAAANVarQNOjR48K7T59+igmJkZxcXEaOXKkXQoDAACoqVpdtl2ZsLAwnTp1yl4vBwAAUGO1mqEZMWJEhTU0ZWVl2rt3r9q2bWu3wgAAAGqqVjM0oaGhatWqlW1r3bq1Jk6cWOP70Jw4cUI9evSQj4+PoqOjlZ6eXu2YpKQkhYSEyMfHR88995zKyspqUzoAALgJOeVp23FxcWrZsqWWLVumiRMnKj4+XsnJyVX2P3LkiOLi4rRixQq1a9dOffv2VYcOHTRq1KgbqgMAANwc7H7ZdrmqLt8uLi7W559/roMHD6pVq1YaOXKkYmJirvlay5cv1/3336+BAwdKkuLj45WUlESgAQAAkmoZaAYOHKgNGzZo8uTJatWqlY4fP67ExET99re/1YMPPnjNsSUlJZo9e7bCwsIkSTk5OfLy8rrmmO3bt6tnz562dpcuXTRlyhQZhlFpsCoqKlJRUZGtnZ+ffz2HBwAATKZWgeZf//qXkpOTdeedd9r2RUVF6aGHHtLrr79+zbGNGjXS888/L+lyuJk7d66eeOKJa445ffq0AgMDbe2mTZuqtLRUOTk5FfaXmzlzJvfEAQDgFlKrRcHFxcVXLeRNS0u7rtcoLS1VTEyM3NzcNGPGjGr7G4Zx1ddVnfZKSEiQxWKxbRkZGddVGwAAMJdazdC89NJLGjRokB5++GEFBwcrIyNDn3zyif73f/+3RuOtVqsee+wxpaen65NPPqn2lFPz5s2VnZ1ta+fk5MjDw0NNmjSptL+np6c8PT1rfkAAAMDUajVD88wzz+iLL77QXXfdpbKyMt1zzz3auXOnnn766RqNf/nll3X8+HF99tlnCggIqLZ/VFSUduzYYWvv2rVL3bt3r3ZhMgAAuDXU+mnbkZGRioyMlHT59JG7e81eKj09XYmJifr8889lGIby8vIkSb6+vsrPz5ePj4/c3NwqjBk6dKhmzpypdevWqV27dlqwYIFeeuml2pYOAABuMrWaoTlx4oR69eqlRo0a6dSpUxo3bpyioqJq9OiDLVu2qLCwUN26dVNAQIBtO3XqlAICApSamnrVmDZt2mjx4sWKj4/Xvffeq759+2rEiBG1KR0AANyEahVoRo4cqcjISHl4eEiSZsyYoV/+8pc1OuU0bNgwGYZx1RYaGirDMBQREVHpuNjYWGVmZur8+fN6++235epqt8dQAQAAk6tVKti3b5/i4+Nta1gCAwP18ssva9euXXYtDgAAoCZqFWjat2+v1NRUubi42ELN3/72N7Vv396uxQEAANRErRYFz5s3T48++qjOnz+v2NhY/fDDD7JYLNqwYYO96wMAAKhWrQJNZGSkDhw4oPXr1yszM1MtWrRQnz595O/vb+fyAAAAqlfry7b9/Pw0dOhQe9YCAABQK7VaQ/POO+8oKyvL3rUAAADUSq0CzZtvvqkDBw7YuxYAAIBaqVWgefnll/Xqq6/qwoUL9q4HAADgutVqDc2xY8dktVp1++2368knn1SjRo1s3/vTn/5kt+IAAABqolaB5uTJk2rXrp3atWuns2fP2vbzsEgAAOAMNQ40S5Ys0ZNPPil3d3e9//77dVkTAADAdanxGppRo0bp0qVLtvbGjRtVWFhYJ0UBAABcjxoHGsMwKrR/97vfVTjdBAAA4Cy1fmT1TwMOAACAs9Q40Fz5IMrK2gAAAM5S40XBhmGoZcuWthCTl5enu+66S66uFTPRjz/+aN8KAQAAqlHjQLN58+a6rAMAAKDWahxoevToUZd1AAAA1FqtFwUDAADUFwQaAABgegQaAABgegQaAABgegQaAABgegQaAABgegQaAABgegQaAABgegQaAABgegQaAABgegQaAABgegQaAABgegQaAABgegQaAABgegQaAABgek4LNFlZWerRo4dSUlKq7Xvy5Em5uLhU2KKjo+u8RgAAYA7uznjT0aNHa9GiRdc1xsPDQ2fPnrW13d2dUjoAAKiHnDJD89prryktLe26xgQFBcnf39+2NW7cuI6qAwAAZuOUQBMYGKjQ0NDrGuPm5qZevXrJ29tbAwcOlMViqbJvUVGR8vPzK2wAAODmZZpFwWfOnFF8fLxSU1N17NgxzZo1q8q+M2fOlJ+fn20LCQlxYKUAAMDRTBFoWrRoofT0dA0aNEitW7fWsGHDtHnz5ir7JyQkyGKx2LaMjAwHVgsAABzNFCtr3d3d1axZM1vb39//mqeRPD095enp6YjSAABAPWCKGZopU6Zo1KhRtvapU6euew0OAAC4edWrQJOXl6eysrKr9kdHR+vDDz/U9u3btW/fPr3//vsaPny44wsEAAD1Ur065RQQEKD9+/crIiKiwv6HH35YL7zwggYPHiw3Nzc9++yzGjJkiHOKBAAA9Y5TA41hGNdsXykhIUEJCQl1XRIAADChenXKCQAAoDYINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPQINAAAwPScFmiysrLUo0cPpaSk1Kh/UlKSQkJC5OPjo+eee05lZWV1WyAAADANpwSa0aNHKzg4WNu2batR/yNHjiguLk7z5s3Tnj17tGHDBi1ZsqSOqwQAAGbhlEDz2muvKS0trcb9ly9frvvvv18DBw7UHXfcofj4eCUlJdVhhQAAwEycEmgCAwMVGhpa4/7bt29Xt27dbO0uXbpo586dMgyj0v5FRUXKz8+vsAEAgJuXu7MLqInTp08rMDDQ1m7atKlKS0uVk5NTYX+5mTNnavr06Q6r72TDoQ57L/uxOLsAwG5CX1zv7BKu28lZfZ1dwq1hmp+zK4CDmOYqpytnY8q/dnFxqbRvQkKCLBaLbcvIyHBIjQAAwDlMMUPTvHlzZWdn29o5OTny8PBQkyZNKu3v6ekpT09PR5UHAACczBQzNFFRUdqxY4etvWvXLnXv3r3KGRoAAHBrqVeBJi8vr9L7ywwdOlRbtmzRunXrdPjwYS1YsECxsbFOqBAAANRH9SrQBAQEKDU19ar9bdq00eLFixUfH697771Xffv21YgRI5xQIQAAqI+cuobmp5ddV3UZtiTFxsYyKwMAACpVr2ZoAAAAaoNAAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATI9AAwAATM8pgWbfvn2KiIiQl5eXevfurbNnz16z/8mTJ+Xi4lJhi46OdkyxAACg3nN4oLFarRo8eLD69euno0ePysvLSxMmTKh2nIeHh3Jzc21bcnKyA6oFAABm4O7oN9y6dat+/PFHTZs2Te7u7po6daruu+8+Xbx4UY0aNapyXFBQkPz9/R1XKAAAMA2Hz9Bs375dnTt3lrv75SwVERGhsrIy7du375rj3Nzc1KtXL3l7e2vgwIGyWCxV9i0qKlJ+fn6FDQAA3LwcHmhOnz6twMDA/y/A1VUBAQE6c+bMNcedOXNG8fHxSk1N1bFjxzRr1qwq+86cOVN+fn62LSQkxG71AwCA+scpi4INw7iq7eLiUmX/Fi1aKD09XYMGDVLr1q01bNgwbd68ucr+CQkJslgsti0jI8NutQMAgPrH4WtomjdvrkOHDtnaZWVlysvLU7Nmzaoc4+7uXuH7/v7+1zyN5OnpKU9PT/sUDAAA6j2Hz9BERUVpz549Ki0tlSTt379f7u7u6tixY5VjpkyZolGjRtnap06dUmhoaF2XCgAATMLhgea+++5TUFCQpk6dqszMTM2YMUODBg2St7e38vLyVFZWdtWY6Ohoffjhh9q+fbv27dun999/X8OHD3d06QAAoJ5yeKBxdXXV6tWrlZycrDZt2qiwsFCJiYmSpICAAKWmpl415uGHH9YLL7ygwYMHq3///nr22Wc1ZMgQR5cOAADqKYevoZGkTp066cCBA1ft/+li4SslJCQoISGhLssCAAAmxbOcAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6RFoAACA6Tkl0Ozbt08RERHy8vJS7969dfbs2WrHJCUlKSQkRD4+PnruuedUVlbmgEoBAIAZODzQWK1WDR48WP369dPRo0fl5eWlCRMmXHPMkSNHFBcXp3nz5mnPnj3asGGDlixZ4qCKAQBAfefwQLN161b9+OOPmjZtmlq0aKGpU6fqo48+0sWLF6scs3z5ct1///0aOHCg7rjjDsXHxyspKcmBVQMAgPrM3dFvuH37dnXu3Fnu7pffOiIiQmVlZdq3b5+ioqKqHNOzZ09bu0uXLpoyZYoMw5CLi8tV/YuKilRUVGRrWywWSVJ+fr49D+WKNzTq5nXrUl19FoATWIsuObuE61Znv49QkRl/P5tVHfw3Xf7vxDCq/zk6PNCcPn1agYGBtrarq6sCAgJ05syZGo9p2rSpSktLlZOTU2F/uZkzZ2r69OlX7Q8JCbnB6m8is/ycXQFwS/N7y9kVAHZWh39Xzp8/Lz+/a7++wwONdHXSqmqmpaox5V9XNSYhIUETJ060ta1Wq3788Uc1bdq02vcxm/z8fIWEhCgjI0O+vr7OLsfhbvXjl/gMbvXjl/gMOP6b9/gNw9D58+cVHBxcbV+HB5rmzZvr0KFDtnZZWZny8vLUrFmza47Jzs62tXNycuTh4aEmTZpU2t/T01Oenp4V9vn7+99Y4fWcr6/vTfcf8vW41Y9f4jO41Y9f4jPg+G/O469uZqacwxcFR0VFac+ePSotLZUk7d+/X+7u7urYseM1x+zYscPW3rVrl7p3737TzbYAAIDacXigue+++xQUFKSpU6cqMzNTM2bM0KBBg+Tt7a28vLxK7y8zdOhQbdmyRevWrdPhw4e1YMECxcbGOrp0AABQTzk80Li6umr16tVKTk5WmzZtVFhYqMTERElSQECAUlNTrxrTpk0bLV68WPHx8br33nvVt29fjRgxwtGl10uenp6aOnXqVafYbhW3+vFLfAa3+vFLfAYc/619/OVcjJpcCwUAAFCP8SwnAABgegQaAABgegQaAABgegQaEztx4oR69OghHx8fRUdHKz093dklOcW2bdvk4uKiLVu2OLsUhyspKdHo0aPl4+Oj9u3ba9euXc4uyaFSU1PVtWtX+fj46MEHH9SpU6ecXZJDZGVlqUePHkpJSbHt+/jjj9W2bVs1atRIjz/+uC5dMt/jIGqqsuPfu3evOnXqJF9fXw0cOFA//vij8wp0gMo+g3LLli2Ti4uLTp486fC6nIlAY2JxcXFq2bKlDh48qKZNmyo+Pt7ZJTlcSUmJxo4d6+wynOaNN95QWlqa9u/fr8cff1xPPPGEs0tyqEceeUT9+vXT999/r9DQUD311FPOLqnOjR49WsHBwdq2bZttX15enoYMGaKJEyfq22+/1cmTJ/Xaa685scq6U9nxW61WDR06VL1799Y333yjs2fP6k9/+pMTq6xblX0G5fLy8jR58mQnVFUPGDCloqIiw8XFxfj2228NwzCM9evXG76+vk6uyvH+/Oc/Gz179jT8/PyMzZs3O7sch2vdurWxf/9+wzAM4/z588bq1auNsrIy5xblIGfPnjUkGVlZWYZhGMaOHTsMb29vJ1dV97Kzs420tDRDku1nv2TJEuPOO++09VmzZo3RsmVLJ1VYtyo7/qNHjxqSjAsXLhiGYRjz5883OnTo4MQq61Zln0G5Z555xvjNb35jSDLS0tKcUp+zMENjUiUlJZo9e7bCwsIkXX4chJeXl5OrcqzMzEzNmjVL8+fPd3YpTnH69GmlpaVp27Zt8vPzU48ePXT33XfL1fXW+GcdEBCgFi1a6OOPP5Z0+ZRLRESEc4tygMDAQIWGhlbYt337dnXr1s3W7tKli06dOqWMjAwHV1f3Kjt+b29vvfXWW2rUqJGkm//3YWWfgXT5tNvq1as1e/ZsxxdVD9wav/luQo0aNdLzzz8vLy8vlZSUaO7cubfc6Ybx48dr9OjRat++vbNLcYqsrCy5uLho9+7dOnDggNq3b68xY8Y4uyyHcXd316pVqzR69Gh5enrq7bff1rJly5xdllOcPn1agYGBtnbTpk0lSWfOnHFWSQ4VHBys8ePHS5IsFovefffdW+73odVq1TPPPKNXX31VQUFBzi7HKQg0JldaWqqYmBi5ublpxowZzi7HYTZt2qS9e/fq5ZdfdnYpTnPx4kWVlZVp6tSpCg0N1bPPPqvNmzeruLjY2aU5REFBgZ588klNnz5d+/btU2xs7C2xhqYqxhX3SC3/+lZ73t2FCxfUt29fdezYUc8884yzy3God955Ry4uLho1apSzS3EaAo2JWa1WPfbYYzp58qQ2bdp0U0+x/tTKlSuVlZWl4OBg+fv7y2KxqF+/fvrggw+cXZrDlD+Btvyp802bNpVhGDf91R3l/vOf/6i4uFhTpkzRL3/5S82ZM0c7duzQN9984+zSHK558+bKzs62tXNyciRJzZo1c1ZJDnfp0iU9+OCD8vX11cqVK2+ZU6/lVq1apW+++UZNmjRRq1atJEkdOnTQl19+6eTKHOfW+onfZF5++WUdP35cn332mQICApxdjkPNmTNH33//vVJSUpSSkiIfHx+9++67GjBggLNLc5g2bdrIw8NDR44ckXT59IKrq2uFUw83Mzc3twoPszUMQ1arVe7u7k6syjmioqK0Y8cOW3vXrl0KDQ3Vz3/+cydW5VijRo1S48aN9c9//vOWfKbRP/7xDx06dEgpKSn64osvJEkbNmxQZGSkkytznFvvX/5NIj09XYmJifr8889lGIby8vIkSb6+vrfE/5kEBgZW+MPt6uqqZs2aqXHjxk6syrG8vLw0YMAAzZgxQwsWLNDcuXP14IMP3jJ/0Lt06aL8/Hy9+eab+u1vf6u33npLISEhuv32251dmsMNHDhQ48aN08KFC/Xwww9rzpw5io2NdXZZDrN9+3YlJyfr66+/1qVLl2z34PH393duYQ505Wxc+d+DFi1aqGHDhk6qyPFu/r98N6ktW7aosLBQ3bp1U0BAgG27VW4shssWLFigsrIyhYeHKysrSwsWLHB2SQ4TFBSk1atXa8mSJWrXrp2+/PJLrV27Vh4eHs4uzeH8/Py0atUqJSYm6s4771RYWJgSEhKcXZbDfPrpp8rPz1fbtm0r/D7ErYWnbQMAANNjhgYAAJgegQYAAJgegQYAAJgegQYAAJgegQYAAJgegQYAAJgegQYAAJgegQYAAJgegQYAAJgegQYAAJgegQYAAJje/wEi7aY8s6oDOgAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "simple.plot(kind='hist') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "67bca6b6",
   "metadata": {},
   "outputs": [],
   "source": [
    "simple.to_csv('./test.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "b69e4aa1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wy企业1333345</td>\n",
       "      <td>8</td>\n",
       "      <td>2023/5/1</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.80%、21.60%、2.16%</td>\n",
       "      <td>0.10%、2.55%、1.02%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/1</td>\n",
       "      <td>13</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wy企业4</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          企业名称  租赁面积/㎡       开始日期       截止日期  租赁天数               总【占比】  \\\n",
       "0  wy企业1333345       8   2023/5/1   2023/7/1     1  0.80%、21.60%、2.16%   \n",
       "1        wy企业3       1  2023/7/17  2024/7/31    15     100.00%、100.00%   \n",
       "2        wy企业3       1  2023/7/17  2024/7/31    15     100.00%、100.00%   \n",
       "3        wy企业3       1  2023/7/19   2024/7/1    13     100.00%、100.00%   \n",
       "4        wy企业4       1  2023/7/18   2024/8/1    14       0.13%、100.00%   \n",
       "\n",
       "            办公用房【占比】  \n",
       "0  0.10%、2.55%、1.02%  \n",
       "1    100.00%、100.00%  \n",
       "2    100.00%、100.00%  \n",
       "3    100.00%、100.00%  \n",
       "4      0.13%、100.00%  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "f3eb8ea5",
   "metadata": {},
   "outputs": [],
   "source": [
    "simple.to_hdf(\"./database/test.h5\", key=\"companyname\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "ed0a5b2e",
   "metadata": {},
   "outputs": [],
   "source": [
    "h5data = pd.read_hdf(\"./database/test.h5\", key=\"companyname\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "f3889678",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wy企业1333345</td>\n",
       "      <td>8</td>\n",
       "      <td>2023/5/1</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.80%、21.60%、2.16%</td>\n",
       "      <td>0.10%、2.55%、1.02%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/1</td>\n",
       "      <td>13</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wy企业4</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          企业名称  租赁面积/㎡       开始日期       截止日期  租赁天数               总【占比】  \\\n",
       "0  wy企业1333345       8   2023/5/1   2023/7/1     1  0.80%、21.60%、2.16%   \n",
       "1        wy企业3       1  2023/7/17  2024/7/31    15     100.00%、100.00%   \n",
       "2        wy企业3       1  2023/7/17  2024/7/31    15     100.00%、100.00%   \n",
       "3        wy企业3       1  2023/7/19   2024/7/1    13     100.00%、100.00%   \n",
       "4        wy企业4       1  2023/7/18   2024/8/1    14       0.13%、100.00%   \n",
       "\n",
       "            办公用房【占比】  \n",
       "0  0.10%、2.55%、1.02%  \n",
       "1    100.00%、100.00%  \n",
       "2    100.00%、100.00%  \n",
       "3    100.00%、100.00%  \n",
       "4      0.13%、100.00%  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "h5data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "5271d8b8",
   "metadata": {},
   "outputs": [],
   "source": [
    "h5data.to_json('./database/test_json.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "8d09b6a6",
   "metadata": {},
   "outputs": [],
   "source": [
    "jsondata = pd.read_json('./database/test_json.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "4d92289d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5, 7)"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "jsondata.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "a2dd22a3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wy企业1333345</td>\n",
       "      <td>8</td>\n",
       "      <td>2023/5/1</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.80%、21.60%、2.16%</td>\n",
       "      <td>0.10%、2.55%、1.02%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/1</td>\n",
       "      <td>13</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wy企业4</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          企业名称  租赁面积/㎡       开始日期       截止日期  租赁天数               总【占比】  \\\n",
       "0  wy企业1333345       8   2023/5/1   2023/7/1     1  0.80%、21.60%、2.16%   \n",
       "1        wy企业3       1  2023/7/17  2024/7/31    15     100.00%、100.00%   \n",
       "2        wy企业3       1  2023/7/17  2024/7/31    15     100.00%、100.00%   \n",
       "3        wy企业3       1  2023/7/19   2024/7/1    13     100.00%、100.00%   \n",
       "4        wy企业4       1  2023/7/18   2024/8/1    14       0.13%、100.00%   \n",
       "\n",
       "            办公用房【占比】  \n",
       "0  0.10%、2.55%、1.02%  \n",
       "1    100.00%、100.00%  \n",
       "2    100.00%、100.00%  \n",
       "3    100.00%、100.00%  \n",
       "4      0.13%、100.00%  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "jsondata"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "d05d8c83",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "simple = pd.read_csv('./database/2023-07能耗费用明细22.csv', encoding = 'gb18030')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "2a0ae151",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "      <th>测试机房【占比】</th>\n",
       "      <th>办公【电费】【含税】</th>\n",
       "      <th>测试机房【电费】【含税】</th>\n",
       "      <th>【水费】【含税】</th>\n",
       "      <th>餐厅【燃气费】【含税】</th>\n",
       "      <th>单位不含税合计</th>\n",
       "      <th>单位税金合计</th>\n",
       "      <th>单位含税合计</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wy企业1333345</td>\n",
       "      <td>8</td>\n",
       "      <td>2023/5/1</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.80%、21.60%、2.16%</td>\n",
       "      <td>0.10%、2.55%、1.02%</td>\n",
       "      <td>1.80%、62.30%、31.15%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>200</td>\n",
       "      <td>178.26</td>\n",
       "      <td>200</td>\n",
       "      <td>524.02</td>\n",
       "      <td>54.24</td>\n",
       "      <td>578.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/1</td>\n",
       "      <td>13</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wy企业4</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>83.19</td>\n",
       "      <td>0</td>\n",
       "      <td>76.32</td>\n",
       "      <td>6.87</td>\n",
       "      <td>83.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>wy企业9</td>\n",
       "      <td>200</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/8/31</td>\n",
       "      <td>31</td>\n",
       "      <td>20.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>wy企业10</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/11</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>21</td>\n",
       "      <td>100.00%、6100.00%、7100.00%</td>\n",
       "      <td>100.00%、100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>249.58</td>\n",
       "      <td>0</td>\n",
       "      <td>228.96</td>\n",
       "      <td>20.60</td>\n",
       "      <td>249.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>23</td>\n",
       "      <td>2023/7/6</td>\n",
       "      <td>2023/7/22</td>\n",
       "      <td>22</td>\n",
       "      <td>2.30%、0.11%</td>\n",
       "      <td>2.90%、0.04%</td>\n",
       "      <td>1.10%、1.65%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>23</td>\n",
       "      <td>2023/7/11</td>\n",
       "      <td>2023/7/21</td>\n",
       "      <td>11</td>\n",
       "      <td>2.30%</td>\n",
       "      <td>0.10%</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>22</td>\n",
       "      <td>2023/7/6</td>\n",
       "      <td>2023/7/21</td>\n",
       "      <td>21</td>\n",
       "      <td>2.20%、0.10%</td>\n",
       "      <td>0.28%、0.05%</td>\n",
       "      <td>0.20%、0.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>23</td>\n",
       "      <td>2023/7/3</td>\n",
       "      <td>2023/7/20</td>\n",
       "      <td>20</td>\n",
       "      <td>2.30%</td>\n",
       "      <td>2.90%</td>\n",
       "      <td>1.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>222</td>\n",
       "      <td>2023/7/4</td>\n",
       "      <td>2023/12/30</td>\n",
       "      <td>31</td>\n",
       "      <td>22.20%</td>\n",
       "      <td>15.39%</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>香港8899</td>\n",
       "      <td>120</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2023/8/31</td>\n",
       "      <td>15</td>\n",
       "      <td>12.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>2.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>香港8899</td>\n",
       "      <td>120</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2024/8/31</td>\n",
       "      <td>31</td>\n",
       "      <td>12.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>2.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>香港8899</td>\n",
       "      <td>100</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/12/31</td>\n",
       "      <td>31</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>1.00%</td>\n",
       "      <td>1.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>300</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2023/11/22</td>\n",
       "      <td>15</td>\n",
       "      <td>30.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>566</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/1/1</td>\n",
       "      <td>14</td>\n",
       "      <td>56.60%、22.20%</td>\n",
       "      <td>5.00%、5.00%</td>\n",
       "      <td>5.00%、1.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>222</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/7/18</td>\n",
       "      <td>14</td>\n",
       "      <td>22.20%</td>\n",
       "      <td>6.89%</td>\n",
       "      <td>0.50%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>444</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/7/4</td>\n",
       "      <td>14</td>\n",
       "      <td>44.40%</td>\n",
       "      <td>0.64%</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>mo-企业对账名称-1</td>\n",
       "      <td>22</td>\n",
       "      <td>2023/7/7</td>\n",
       "      <td>2023/8/16</td>\n",
       "      <td>31</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>0.29%</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>前途有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/7/7</td>\n",
       "      <td>7</td>\n",
       "      <td>0.10%</td>\n",
       "      <td>0.14%</td>\n",
       "      <td>1.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>前途有限公司</td>\n",
       "      <td>12</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/10/27</td>\n",
       "      <td>31</td>\n",
       "      <td>1.20%</td>\n",
       "      <td>0.41%</td>\n",
       "      <td>11.30%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>合并测试企业1</td>\n",
       "      <td>500</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/19</td>\n",
       "      <td>13</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>15.00%</td>\n",
       "      <td>5.50%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>合并测试企业1</td>\n",
       "      <td>100</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/19</td>\n",
       "      <td>13</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>0.28%</td>\n",
       "      <td>3.30%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>跨年企业1</td>\n",
       "      <td>333</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2025/12/31</td>\n",
       "      <td>897</td>\n",
       "      <td>33.30%</td>\n",
       "      <td>6.94%</td>\n",
       "      <td>5.60%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>跨年企业2</td>\n",
       "      <td>222</td>\n",
       "      <td>2023/7/20</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>31</td>\n",
       "      <td>22.20%、6.66%</td>\n",
       "      <td>5.55%、10.44%</td>\n",
       "      <td>55.50%、5.55%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           企业名称  租赁面积/㎡       开始日期        截止日期  租赁天数  \\\n",
       "0   wy企业1333345       8   2023/5/1    2023/7/1     1   \n",
       "1         wy企业3       1  2023/7/17   2024/7/31    15   \n",
       "2         wy企业3       1  2023/7/17   2024/7/31    15   \n",
       "3         wy企业3       1  2023/7/19    2024/7/1    13   \n",
       "4         wy企业4       1  2023/7/18    2024/8/1    14   \n",
       "5         wy企业9     200   2023/7/1   2023/8/31    31   \n",
       "6        wy企业10       1  2023/7/11   2024/7/31    21   \n",
       "7        技术有限公司      23   2023/7/6   2023/7/22    22   \n",
       "8        技术有限公司      23  2023/7/11   2023/7/21    11   \n",
       "9        技术有限公司      22   2023/7/6   2023/7/21    21   \n",
       "10       技术有限公司      23   2023/7/3   2023/7/20    20   \n",
       "11       技术有限公司     222   2023/7/4  2023/12/30    31   \n",
       "12       香港8899     120  2023/7/17   2023/8/31    15   \n",
       "13       香港8899     120   2023/7/1   2024/8/31    31   \n",
       "14       香港8899     100   2023/7/1  2023/12/31    31   \n",
       "15       取暖费企业1     300  2023/7/17  2023/11/22    15   \n",
       "16       取暖费企业1     566  2023/7/18    2024/1/1    14   \n",
       "17       取暖费企业1     222  2023/7/18   2024/7/18    14   \n",
       "18       取暖费企业1     444  2023/7/18    2024/7/4    14   \n",
       "19  mo-企业对账名称-1      22   2023/7/7   2023/8/16    31   \n",
       "20       前途有限公司       1   2023/7/1    2023/7/7     7   \n",
       "21       前途有限公司      12   2023/7/1  2023/10/27    31   \n",
       "22      合并测试企业1     500  2023/7/19   2024/7/19    13   \n",
       "23      合并测试企业1     100  2023/7/19   2024/7/19    13   \n",
       "24        跨年企业1     333  2023/7/19  2025/12/31   897   \n",
       "25        跨年企业2     222  2023/7/20    2024/8/1    31   \n",
       "\n",
       "                        总【占比】                 办公用房【占比】  \\\n",
       "0          0.80%、21.60%、2.16%        0.10%、2.55%、1.02%   \n",
       "1             100.00%、100.00%          100.00%、100.00%   \n",
       "2             100.00%、100.00%          100.00%、100.00%   \n",
       "3             100.00%、100.00%          100.00%、100.00%   \n",
       "4               0.13%、100.00%            0.13%、100.00%   \n",
       "5                      20.00%                    1.25%   \n",
       "6   100.00%、6100.00%、7100.00%  100.00%、100.00%、100.00%   \n",
       "7                 2.30%、0.11%              2.90%、0.04%   \n",
       "8                       2.30%                    0.10%   \n",
       "9                 2.20%、0.10%              0.28%、0.05%   \n",
       "10                      2.30%                    2.90%   \n",
       "11                     22.20%                   15.39%   \n",
       "12                     12.00%                    1.25%   \n",
       "13                     12.00%                    1.25%   \n",
       "14                     10.00%                    1.00%   \n",
       "15                     30.00%                    1.25%   \n",
       "16              56.60%、22.20%              5.00%、5.00%   \n",
       "17                     22.20%                    6.89%   \n",
       "18                     44.40%                    0.64%   \n",
       "19                      2.20%                    0.29%   \n",
       "20                      0.10%                    0.14%   \n",
       "21                      1.20%                    0.41%   \n",
       "22                     50.00%                   15.00%   \n",
       "23                     10.00%                    0.28%   \n",
       "24                     33.30%                    6.94%   \n",
       "25               22.20%、6.66%             5.55%、10.44%   \n",
       "\n",
       "                   测试机房【占比】  办公【电费】【含税】  测试机房【电费】【含税】  【水费】【含税】  餐厅【燃气费】【含税】  \\\n",
       "0       1.80%、62.30%、31.15%           0             0      0.00            0   \n",
       "1           100.00%、100.00%           0           200    178.26          200   \n",
       "2           100.00%、100.00%           0             0      0.00            0   \n",
       "3           100.00%、100.00%           0             0      0.00            0   \n",
       "4             0.13%、100.00%           0             0     83.19            0   \n",
       "5                    10.00%           0             0      0.00            0   \n",
       "6   100.00%、100.00%、100.00%           0             0    249.58            0   \n",
       "7               1.10%、1.65%           0             0      0.00            0   \n",
       "8                     0.20%           0             0      0.00            0   \n",
       "9               0.20%、0.10%           0             0      0.00            0   \n",
       "10                    1.10%           0             0      0.00            0   \n",
       "11                    2.20%           0             0      0.00            0   \n",
       "12                    2.00%           0             0      0.00            0   \n",
       "13                    2.00%           0             0      0.00            0   \n",
       "14                    1.00%           0             0      0.00            0   \n",
       "15                   50.00%           0             0      0.00            0   \n",
       "16              5.00%、1.10%           0             0      0.00            0   \n",
       "17                    0.50%           0             0      0.00            0   \n",
       "18                    0.20%           0             0      0.00            0   \n",
       "19                    2.20%           0             0      0.00            0   \n",
       "20                    1.10%           0             0      0.00            0   \n",
       "21                   11.30%           0             0      0.00            0   \n",
       "22                    5.50%           0             0      0.00            0   \n",
       "23                    3.30%           0             0      0.00            0   \n",
       "24                    5.60%           0             0      0.00            0   \n",
       "25             55.50%、5.55%           0             0      0.00            0   \n",
       "\n",
       "    单位不含税合计  单位税金合计  单位含税合计  \n",
       "0      0.00    0.00    0.00  \n",
       "1    524.02   54.24  578.26  \n",
       "2      0.00    0.00    0.00  \n",
       "3      0.00    0.00    0.00  \n",
       "4     76.32    6.87   83.19  \n",
       "5      0.00    0.00    0.00  \n",
       "6    228.96   20.60  249.58  \n",
       "7      0.00    0.00    0.00  \n",
       "8      0.00    0.00    0.00  \n",
       "9      0.00    0.00    0.00  \n",
       "10     0.00    0.00    0.00  \n",
       "11     0.00    0.00    0.00  \n",
       "12     0.00    0.00    0.00  \n",
       "13     0.00    0.00    0.00  \n",
       "14     0.00    0.00    0.00  \n",
       "15     0.00    0.00    0.00  \n",
       "16     0.00    0.00    0.00  \n",
       "17     0.00    0.00    0.00  \n",
       "18     0.00    0.00    0.00  \n",
       "19     0.00    0.00    0.00  \n",
       "20     0.00    0.00    0.00  \n",
       "21     0.00    0.00    0.00  \n",
       "22     0.00    0.00    0.00  \n",
       "23     0.00    0.00    0.00  \n",
       "24     0.00    0.00    0.00  \n",
       "25     0.00    0.00    0.00  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "2b19ef2f",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in simple.columns:\n",
    "   if np.any(pd.isnull(simple[i])) == True:\n",
    "       simple[i].fillna(value=simple[i].mean(),inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "e7e3fd35",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "      <th>测试机房【占比】</th>\n",
       "      <th>办公【电费】【含税】</th>\n",
       "      <th>测试机房【电费】【含税】</th>\n",
       "      <th>【水费】【含税】</th>\n",
       "      <th>餐厅【燃气费】【含税】</th>\n",
       "      <th>单位不含税合计</th>\n",
       "      <th>单位税金合计</th>\n",
       "      <th>单位含税合计</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wy企业1333345</td>\n",
       "      <td>8</td>\n",
       "      <td>2023/5/1</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.80%、21.60%、2.16%</td>\n",
       "      <td>0.10%、2.55%、1.02%</td>\n",
       "      <td>1.80%、62.30%、31.15%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>200</td>\n",
       "      <td>178.26</td>\n",
       "      <td>200</td>\n",
       "      <td>524.02</td>\n",
       "      <td>54.24</td>\n",
       "      <td>578.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/1</td>\n",
       "      <td>13</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wy企业4</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>83.19</td>\n",
       "      <td>0</td>\n",
       "      <td>76.32</td>\n",
       "      <td>6.87</td>\n",
       "      <td>83.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>wy企业9</td>\n",
       "      <td>200</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/8/31</td>\n",
       "      <td>31</td>\n",
       "      <td>20.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>wy企业10</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/11</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>21</td>\n",
       "      <td>100.00%、6100.00%、7100.00%</td>\n",
       "      <td>100.00%、100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>249.58</td>\n",
       "      <td>0</td>\n",
       "      <td>228.96</td>\n",
       "      <td>20.60</td>\n",
       "      <td>249.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>23</td>\n",
       "      <td>2023/7/6</td>\n",
       "      <td>2023/7/22</td>\n",
       "      <td>22</td>\n",
       "      <td>2.30%、0.11%</td>\n",
       "      <td>2.90%、0.04%</td>\n",
       "      <td>1.10%、1.65%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>23</td>\n",
       "      <td>2023/7/11</td>\n",
       "      <td>2023/7/21</td>\n",
       "      <td>11</td>\n",
       "      <td>2.30%</td>\n",
       "      <td>0.10%</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>22</td>\n",
       "      <td>2023/7/6</td>\n",
       "      <td>2023/7/21</td>\n",
       "      <td>21</td>\n",
       "      <td>2.20%、0.10%</td>\n",
       "      <td>0.28%、0.05%</td>\n",
       "      <td>0.20%、0.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>23</td>\n",
       "      <td>2023/7/3</td>\n",
       "      <td>2023/7/20</td>\n",
       "      <td>20</td>\n",
       "      <td>2.30%</td>\n",
       "      <td>2.90%</td>\n",
       "      <td>1.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>222</td>\n",
       "      <td>2023/7/4</td>\n",
       "      <td>2023/12/30</td>\n",
       "      <td>31</td>\n",
       "      <td>22.20%</td>\n",
       "      <td>15.39%</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>香港8899</td>\n",
       "      <td>120</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2023/8/31</td>\n",
       "      <td>15</td>\n",
       "      <td>12.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>2.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>香港8899</td>\n",
       "      <td>120</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2024/8/31</td>\n",
       "      <td>31</td>\n",
       "      <td>12.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>2.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>香港8899</td>\n",
       "      <td>100</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/12/31</td>\n",
       "      <td>31</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>1.00%</td>\n",
       "      <td>1.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>300</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2023/11/22</td>\n",
       "      <td>15</td>\n",
       "      <td>30.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>566</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/1/1</td>\n",
       "      <td>14</td>\n",
       "      <td>56.60%、22.20%</td>\n",
       "      <td>5.00%、5.00%</td>\n",
       "      <td>5.00%、1.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>222</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/7/18</td>\n",
       "      <td>14</td>\n",
       "      <td>22.20%</td>\n",
       "      <td>6.89%</td>\n",
       "      <td>0.50%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>444</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/7/4</td>\n",
       "      <td>14</td>\n",
       "      <td>44.40%</td>\n",
       "      <td>0.64%</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>mo-企业对账名称-1</td>\n",
       "      <td>22</td>\n",
       "      <td>2023/7/7</td>\n",
       "      <td>2023/8/16</td>\n",
       "      <td>31</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>0.29%</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>前途有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/7/7</td>\n",
       "      <td>7</td>\n",
       "      <td>0.10%</td>\n",
       "      <td>0.14%</td>\n",
       "      <td>1.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>前途有限公司</td>\n",
       "      <td>12</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/10/27</td>\n",
       "      <td>31</td>\n",
       "      <td>1.20%</td>\n",
       "      <td>0.41%</td>\n",
       "      <td>11.30%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>合并测试企业1</td>\n",
       "      <td>500</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/19</td>\n",
       "      <td>13</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>15.00%</td>\n",
       "      <td>5.50%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>合并测试企业1</td>\n",
       "      <td>100</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/19</td>\n",
       "      <td>13</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>0.28%</td>\n",
       "      <td>3.30%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>跨年企业1</td>\n",
       "      <td>333</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2025/12/31</td>\n",
       "      <td>897</td>\n",
       "      <td>33.30%</td>\n",
       "      <td>6.94%</td>\n",
       "      <td>5.60%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>跨年企业2</td>\n",
       "      <td>222</td>\n",
       "      <td>2023/7/20</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>31</td>\n",
       "      <td>22.20%、6.66%</td>\n",
       "      <td>5.55%、10.44%</td>\n",
       "      <td>55.50%、5.55%</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           企业名称  租赁面积/㎡       开始日期        截止日期  租赁天数  \\\n",
       "0   wy企业1333345       8   2023/5/1    2023/7/1     1   \n",
       "1         wy企业3       1  2023/7/17   2024/7/31    15   \n",
       "2         wy企业3       1  2023/7/17   2024/7/31    15   \n",
       "3         wy企业3       1  2023/7/19    2024/7/1    13   \n",
       "4         wy企业4       1  2023/7/18    2024/8/1    14   \n",
       "5         wy企业9     200   2023/7/1   2023/8/31    31   \n",
       "6        wy企业10       1  2023/7/11   2024/7/31    21   \n",
       "7        技术有限公司      23   2023/7/6   2023/7/22    22   \n",
       "8        技术有限公司      23  2023/7/11   2023/7/21    11   \n",
       "9        技术有限公司      22   2023/7/6   2023/7/21    21   \n",
       "10       技术有限公司      23   2023/7/3   2023/7/20    20   \n",
       "11       技术有限公司     222   2023/7/4  2023/12/30    31   \n",
       "12       香港8899     120  2023/7/17   2023/8/31    15   \n",
       "13       香港8899     120   2023/7/1   2024/8/31    31   \n",
       "14       香港8899     100   2023/7/1  2023/12/31    31   \n",
       "15       取暖费企业1     300  2023/7/17  2023/11/22    15   \n",
       "16       取暖费企业1     566  2023/7/18    2024/1/1    14   \n",
       "17       取暖费企业1     222  2023/7/18   2024/7/18    14   \n",
       "18       取暖费企业1     444  2023/7/18    2024/7/4    14   \n",
       "19  mo-企业对账名称-1      22   2023/7/7   2023/8/16    31   \n",
       "20       前途有限公司       1   2023/7/1    2023/7/7     7   \n",
       "21       前途有限公司      12   2023/7/1  2023/10/27    31   \n",
       "22      合并测试企业1     500  2023/7/19   2024/7/19    13   \n",
       "23      合并测试企业1     100  2023/7/19   2024/7/19    13   \n",
       "24        跨年企业1     333  2023/7/19  2025/12/31   897   \n",
       "25        跨年企业2     222  2023/7/20    2024/8/1    31   \n",
       "\n",
       "                        总【占比】                 办公用房【占比】  \\\n",
       "0          0.80%、21.60%、2.16%        0.10%、2.55%、1.02%   \n",
       "1             100.00%、100.00%          100.00%、100.00%   \n",
       "2             100.00%、100.00%          100.00%、100.00%   \n",
       "3             100.00%、100.00%          100.00%、100.00%   \n",
       "4               0.13%、100.00%            0.13%、100.00%   \n",
       "5                      20.00%                    1.25%   \n",
       "6   100.00%、6100.00%、7100.00%  100.00%、100.00%、100.00%   \n",
       "7                 2.30%、0.11%              2.90%、0.04%   \n",
       "8                       2.30%                    0.10%   \n",
       "9                 2.20%、0.10%              0.28%、0.05%   \n",
       "10                      2.30%                    2.90%   \n",
       "11                     22.20%                   15.39%   \n",
       "12                     12.00%                    1.25%   \n",
       "13                     12.00%                    1.25%   \n",
       "14                     10.00%                    1.00%   \n",
       "15                     30.00%                    1.25%   \n",
       "16              56.60%、22.20%              5.00%、5.00%   \n",
       "17                     22.20%                    6.89%   \n",
       "18                     44.40%                    0.64%   \n",
       "19                      2.20%                    0.29%   \n",
       "20                      0.10%                    0.14%   \n",
       "21                      1.20%                    0.41%   \n",
       "22                     50.00%                   15.00%   \n",
       "23                     10.00%                    0.28%   \n",
       "24                     33.30%                    6.94%   \n",
       "25               22.20%、6.66%             5.55%、10.44%   \n",
       "\n",
       "                   测试机房【占比】  办公【电费】【含税】  测试机房【电费】【含税】  【水费】【含税】  餐厅【燃气费】【含税】  \\\n",
       "0       1.80%、62.30%、31.15%           0             0      0.00            0   \n",
       "1           100.00%、100.00%           0           200    178.26          200   \n",
       "2           100.00%、100.00%           0             0      0.00            0   \n",
       "3           100.00%、100.00%           0             0      0.00            0   \n",
       "4             0.13%、100.00%           0             0     83.19            0   \n",
       "5                    10.00%           0             0      0.00            0   \n",
       "6   100.00%、100.00%、100.00%           0             0    249.58            0   \n",
       "7               1.10%、1.65%           0             0      0.00            0   \n",
       "8                     0.20%           0             0      0.00            0   \n",
       "9               0.20%、0.10%           0             0      0.00            0   \n",
       "10                    1.10%           0             0      0.00            0   \n",
       "11                    2.20%           0             0      0.00            0   \n",
       "12                    2.00%           0             0      0.00            0   \n",
       "13                    2.00%           0             0      0.00            0   \n",
       "14                    1.00%           0             0      0.00            0   \n",
       "15                   50.00%           0             0      0.00            0   \n",
       "16              5.00%、1.10%           0             0      0.00            0   \n",
       "17                    0.50%           0             0      0.00            0   \n",
       "18                    0.20%           0             0      0.00            0   \n",
       "19                    2.20%           0             0      0.00            0   \n",
       "20                    1.10%           0             0      0.00            0   \n",
       "21                   11.30%           0             0      0.00            0   \n",
       "22                    5.50%           0             0      0.00            0   \n",
       "23                    3.30%           0             0      0.00            0   \n",
       "24                    5.60%           0             0      0.00            0   \n",
       "25             55.50%、5.55%           0             0      0.00            0   \n",
       "\n",
       "    单位不含税合计  单位税金合计  单位含税合计  \n",
       "0      0.00    0.00    0.00  \n",
       "1    524.02   54.24  578.26  \n",
       "2      0.00    0.00    0.00  \n",
       "3      0.00    0.00    0.00  \n",
       "4     76.32    6.87   83.19  \n",
       "5      0.00    0.00    0.00  \n",
       "6    228.96   20.60  249.58  \n",
       "7      0.00    0.00    0.00  \n",
       "8      0.00    0.00    0.00  \n",
       "9      0.00    0.00    0.00  \n",
       "10     0.00    0.00    0.00  \n",
       "11     0.00    0.00    0.00  \n",
       "12     0.00    0.00    0.00  \n",
       "13     0.00    0.00    0.00  \n",
       "14     0.00    0.00    0.00  \n",
       "15     0.00    0.00    0.00  \n",
       "16     0.00    0.00    0.00  \n",
       "17     0.00    0.00    0.00  \n",
       "18     0.00    0.00    0.00  \n",
       "19     0.00    0.00    0.00  \n",
       "20     0.00    0.00    0.00  \n",
       "21     0.00    0.00    0.00  \n",
       "22     0.00    0.00    0.00  \n",
       "23     0.00    0.00    0.00  \n",
       "24     0.00    0.00    0.00  \n",
       "25     0.00    0.00    0.00  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "02fabebc",
   "metadata": {},
   "outputs": [],
   "source": [
    "simple = simple.replace(to_replace=200, value=np.nan)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "7fe88fe4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "      <th>测试机房【占比】</th>\n",
       "      <th>办公【电费】【含税】</th>\n",
       "      <th>测试机房【电费】【含税】</th>\n",
       "      <th>【水费】【含税】</th>\n",
       "      <th>餐厅【燃气费】【含税】</th>\n",
       "      <th>单位不含税合计</th>\n",
       "      <th>单位税金合计</th>\n",
       "      <th>单位含税合计</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wy企业1333345</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2023/5/1</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.80%、21.60%、2.16%</td>\n",
       "      <td>0.10%、2.55%、1.02%</td>\n",
       "      <td>1.80%、62.30%、31.15%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>178.26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>524.02</td>\n",
       "      <td>54.24</td>\n",
       "      <td>578.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/1</td>\n",
       "      <td>13</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wy企业4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>83.19</td>\n",
       "      <td>0.0</td>\n",
       "      <td>76.32</td>\n",
       "      <td>6.87</td>\n",
       "      <td>83.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>wy企业9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/8/31</td>\n",
       "      <td>31</td>\n",
       "      <td>20.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>wy企业10</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2023/7/11</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>21</td>\n",
       "      <td>100.00%、6100.00%、7100.00%</td>\n",
       "      <td>100.00%、100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>249.58</td>\n",
       "      <td>0.0</td>\n",
       "      <td>228.96</td>\n",
       "      <td>20.60</td>\n",
       "      <td>249.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>23.0</td>\n",
       "      <td>2023/7/6</td>\n",
       "      <td>2023/7/22</td>\n",
       "      <td>22</td>\n",
       "      <td>2.30%、0.11%</td>\n",
       "      <td>2.90%、0.04%</td>\n",
       "      <td>1.10%、1.65%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>23.0</td>\n",
       "      <td>2023/7/11</td>\n",
       "      <td>2023/7/21</td>\n",
       "      <td>11</td>\n",
       "      <td>2.30%</td>\n",
       "      <td>0.10%</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>22.0</td>\n",
       "      <td>2023/7/6</td>\n",
       "      <td>2023/7/21</td>\n",
       "      <td>21</td>\n",
       "      <td>2.20%、0.10%</td>\n",
       "      <td>0.28%、0.05%</td>\n",
       "      <td>0.20%、0.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>23.0</td>\n",
       "      <td>2023/7/3</td>\n",
       "      <td>2023/7/20</td>\n",
       "      <td>20</td>\n",
       "      <td>2.30%</td>\n",
       "      <td>2.90%</td>\n",
       "      <td>1.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>222.0</td>\n",
       "      <td>2023/7/4</td>\n",
       "      <td>2023/12/30</td>\n",
       "      <td>31</td>\n",
       "      <td>22.20%</td>\n",
       "      <td>15.39%</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>香港8899</td>\n",
       "      <td>120.0</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2023/8/31</td>\n",
       "      <td>15</td>\n",
       "      <td>12.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>2.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>香港8899</td>\n",
       "      <td>120.0</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2024/8/31</td>\n",
       "      <td>31</td>\n",
       "      <td>12.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>2.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>香港8899</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/12/31</td>\n",
       "      <td>31</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>1.00%</td>\n",
       "      <td>1.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>300.0</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2023/11/22</td>\n",
       "      <td>15</td>\n",
       "      <td>30.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>566.0</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/1/1</td>\n",
       "      <td>14</td>\n",
       "      <td>56.60%、22.20%</td>\n",
       "      <td>5.00%、5.00%</td>\n",
       "      <td>5.00%、1.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>222.0</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/7/18</td>\n",
       "      <td>14</td>\n",
       "      <td>22.20%</td>\n",
       "      <td>6.89%</td>\n",
       "      <td>0.50%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>444.0</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/7/4</td>\n",
       "      <td>14</td>\n",
       "      <td>44.40%</td>\n",
       "      <td>0.64%</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>mo-企业对账名称-1</td>\n",
       "      <td>22.0</td>\n",
       "      <td>2023/7/7</td>\n",
       "      <td>2023/8/16</td>\n",
       "      <td>31</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>0.29%</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>前途有限公司</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/7/7</td>\n",
       "      <td>7</td>\n",
       "      <td>0.10%</td>\n",
       "      <td>0.14%</td>\n",
       "      <td>1.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>前途有限公司</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/10/27</td>\n",
       "      <td>31</td>\n",
       "      <td>1.20%</td>\n",
       "      <td>0.41%</td>\n",
       "      <td>11.30%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>合并测试企业1</td>\n",
       "      <td>500.0</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/19</td>\n",
       "      <td>13</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>15.00%</td>\n",
       "      <td>5.50%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>合并测试企业1</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/19</td>\n",
       "      <td>13</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>0.28%</td>\n",
       "      <td>3.30%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>跨年企业1</td>\n",
       "      <td>333.0</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2025/12/31</td>\n",
       "      <td>897</td>\n",
       "      <td>33.30%</td>\n",
       "      <td>6.94%</td>\n",
       "      <td>5.60%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>跨年企业2</td>\n",
       "      <td>222.0</td>\n",
       "      <td>2023/7/20</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>31</td>\n",
       "      <td>22.20%、6.66%</td>\n",
       "      <td>5.55%、10.44%</td>\n",
       "      <td>55.50%、5.55%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           企业名称  租赁面积/㎡       开始日期        截止日期  租赁天数  \\\n",
       "0   wy企业1333345     8.0   2023/5/1    2023/7/1     1   \n",
       "1         wy企业3     1.0  2023/7/17   2024/7/31    15   \n",
       "2         wy企业3     1.0  2023/7/17   2024/7/31    15   \n",
       "3         wy企业3     1.0  2023/7/19    2024/7/1    13   \n",
       "4         wy企业4     1.0  2023/7/18    2024/8/1    14   \n",
       "5         wy企业9     NaN   2023/7/1   2023/8/31    31   \n",
       "6        wy企业10     1.0  2023/7/11   2024/7/31    21   \n",
       "7        技术有限公司    23.0   2023/7/6   2023/7/22    22   \n",
       "8        技术有限公司    23.0  2023/7/11   2023/7/21    11   \n",
       "9        技术有限公司    22.0   2023/7/6   2023/7/21    21   \n",
       "10       技术有限公司    23.0   2023/7/3   2023/7/20    20   \n",
       "11       技术有限公司   222.0   2023/7/4  2023/12/30    31   \n",
       "12       香港8899   120.0  2023/7/17   2023/8/31    15   \n",
       "13       香港8899   120.0   2023/7/1   2024/8/31    31   \n",
       "14       香港8899   100.0   2023/7/1  2023/12/31    31   \n",
       "15       取暖费企业1   300.0  2023/7/17  2023/11/22    15   \n",
       "16       取暖费企业1   566.0  2023/7/18    2024/1/1    14   \n",
       "17       取暖费企业1   222.0  2023/7/18   2024/7/18    14   \n",
       "18       取暖费企业1   444.0  2023/7/18    2024/7/4    14   \n",
       "19  mo-企业对账名称-1    22.0   2023/7/7   2023/8/16    31   \n",
       "20       前途有限公司     1.0   2023/7/1    2023/7/7     7   \n",
       "21       前途有限公司    12.0   2023/7/1  2023/10/27    31   \n",
       "22      合并测试企业1   500.0  2023/7/19   2024/7/19    13   \n",
       "23      合并测试企业1   100.0  2023/7/19   2024/7/19    13   \n",
       "24        跨年企业1   333.0  2023/7/19  2025/12/31   897   \n",
       "25        跨年企业2   222.0  2023/7/20    2024/8/1    31   \n",
       "\n",
       "                        总【占比】                 办公用房【占比】  \\\n",
       "0          0.80%、21.60%、2.16%        0.10%、2.55%、1.02%   \n",
       "1             100.00%、100.00%          100.00%、100.00%   \n",
       "2             100.00%、100.00%          100.00%、100.00%   \n",
       "3             100.00%、100.00%          100.00%、100.00%   \n",
       "4               0.13%、100.00%            0.13%、100.00%   \n",
       "5                      20.00%                    1.25%   \n",
       "6   100.00%、6100.00%、7100.00%  100.00%、100.00%、100.00%   \n",
       "7                 2.30%、0.11%              2.90%、0.04%   \n",
       "8                       2.30%                    0.10%   \n",
       "9                 2.20%、0.10%              0.28%、0.05%   \n",
       "10                      2.30%                    2.90%   \n",
       "11                     22.20%                   15.39%   \n",
       "12                     12.00%                    1.25%   \n",
       "13                     12.00%                    1.25%   \n",
       "14                     10.00%                    1.00%   \n",
       "15                     30.00%                    1.25%   \n",
       "16              56.60%、22.20%              5.00%、5.00%   \n",
       "17                     22.20%                    6.89%   \n",
       "18                     44.40%                    0.64%   \n",
       "19                      2.20%                    0.29%   \n",
       "20                      0.10%                    0.14%   \n",
       "21                      1.20%                    0.41%   \n",
       "22                     50.00%                   15.00%   \n",
       "23                     10.00%                    0.28%   \n",
       "24                     33.30%                    6.94%   \n",
       "25               22.20%、6.66%             5.55%、10.44%   \n",
       "\n",
       "                   测试机房【占比】  办公【电费】【含税】  测试机房【电费】【含税】  【水费】【含税】  餐厅【燃气费】【含税】  \\\n",
       "0       1.80%、62.30%、31.15%           0           0.0      0.00          0.0   \n",
       "1           100.00%、100.00%           0           NaN    178.26          NaN   \n",
       "2           100.00%、100.00%           0           0.0      0.00          0.0   \n",
       "3           100.00%、100.00%           0           0.0      0.00          0.0   \n",
       "4             0.13%、100.00%           0           0.0     83.19          0.0   \n",
       "5                    10.00%           0           0.0      0.00          0.0   \n",
       "6   100.00%、100.00%、100.00%           0           0.0    249.58          0.0   \n",
       "7               1.10%、1.65%           0           0.0      0.00          0.0   \n",
       "8                     0.20%           0           0.0      0.00          0.0   \n",
       "9               0.20%、0.10%           0           0.0      0.00          0.0   \n",
       "10                    1.10%           0           0.0      0.00          0.0   \n",
       "11                    2.20%           0           0.0      0.00          0.0   \n",
       "12                    2.00%           0           0.0      0.00          0.0   \n",
       "13                    2.00%           0           0.0      0.00          0.0   \n",
       "14                    1.00%           0           0.0      0.00          0.0   \n",
       "15                   50.00%           0           0.0      0.00          0.0   \n",
       "16              5.00%、1.10%           0           0.0      0.00          0.0   \n",
       "17                    0.50%           0           0.0      0.00          0.0   \n",
       "18                    0.20%           0           0.0      0.00          0.0   \n",
       "19                    2.20%           0           0.0      0.00          0.0   \n",
       "20                    1.10%           0           0.0      0.00          0.0   \n",
       "21                   11.30%           0           0.0      0.00          0.0   \n",
       "22                    5.50%           0           0.0      0.00          0.0   \n",
       "23                    3.30%           0           0.0      0.00          0.0   \n",
       "24                    5.60%           0           0.0      0.00          0.0   \n",
       "25             55.50%、5.55%           0           0.0      0.00          0.0   \n",
       "\n",
       "    单位不含税合计  单位税金合计  单位含税合计  \n",
       "0      0.00    0.00    0.00  \n",
       "1    524.02   54.24  578.26  \n",
       "2      0.00    0.00    0.00  \n",
       "3      0.00    0.00    0.00  \n",
       "4     76.32    6.87   83.19  \n",
       "5      0.00    0.00    0.00  \n",
       "6    228.96   20.60  249.58  \n",
       "7      0.00    0.00    0.00  \n",
       "8      0.00    0.00    0.00  \n",
       "9      0.00    0.00    0.00  \n",
       "10     0.00    0.00    0.00  \n",
       "11     0.00    0.00    0.00  \n",
       "12     0.00    0.00    0.00  \n",
       "13     0.00    0.00    0.00  \n",
       "14     0.00    0.00    0.00  \n",
       "15     0.00    0.00    0.00  \n",
       "16     0.00    0.00    0.00  \n",
       "17     0.00    0.00    0.00  \n",
       "18     0.00    0.00    0.00  \n",
       "19     0.00    0.00    0.00  \n",
       "20     0.00    0.00    0.00  \n",
       "21     0.00    0.00    0.00  \n",
       "22     0.00    0.00    0.00  \n",
       "23     0.00    0.00    0.00  \n",
       "24     0.00    0.00    0.00  \n",
       "25     0.00    0.00    0.00  "
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "80408ac9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.any(pd.isnull(simple['测试机房【电费】【含税】']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "493d310d",
   "metadata": {},
   "outputs": [],
   "source": [
    "simple['测试机房【电费】【含税】'].fillna(value=simple['测试机房【电费】【含税】'].mean(), inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "5bcd5c3b",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in simple.columns:\n",
    "    if np.all(pd.notnull(simple[i])) == False:\n",
    "        simple[i].fillna(value=simple[i].mean(), inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "25c8fa8c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>企业名称</th>\n",
       "      <th>租赁面积/㎡</th>\n",
       "      <th>开始日期</th>\n",
       "      <th>截止日期</th>\n",
       "      <th>租赁天数</th>\n",
       "      <th>总【占比】</th>\n",
       "      <th>办公用房【占比】</th>\n",
       "      <th>测试机房【占比】</th>\n",
       "      <th>办公【电费】【含税】</th>\n",
       "      <th>测试机房【电费】【含税】</th>\n",
       "      <th>【水费】【含税】</th>\n",
       "      <th>餐厅【燃气费】【含税】</th>\n",
       "      <th>单位不含税合计</th>\n",
       "      <th>单位税金合计</th>\n",
       "      <th>单位含税合计</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wy企业1333345</td>\n",
       "      <td>8.00</td>\n",
       "      <td>2023/5/1</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.80%、21.60%、2.16%</td>\n",
       "      <td>0.10%、2.55%、1.02%</td>\n",
       "      <td>1.80%、62.30%、31.15%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>178.26</td>\n",
       "      <td>0.0</td>\n",
       "      <td>524.02</td>\n",
       "      <td>54.24</td>\n",
       "      <td>578.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>15</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wy企业3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/1</td>\n",
       "      <td>13</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wy企业4</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0.13%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>83.19</td>\n",
       "      <td>0.0</td>\n",
       "      <td>76.32</td>\n",
       "      <td>6.87</td>\n",
       "      <td>83.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>wy企业9</td>\n",
       "      <td>135.52</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/8/31</td>\n",
       "      <td>31</td>\n",
       "      <td>20.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>wy企业10</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2023/7/11</td>\n",
       "      <td>2024/7/31</td>\n",
       "      <td>21</td>\n",
       "      <td>100.00%、6100.00%、7100.00%</td>\n",
       "      <td>100.00%、100.00%、100.00%</td>\n",
       "      <td>100.00%、100.00%、100.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>249.58</td>\n",
       "      <td>0.0</td>\n",
       "      <td>228.96</td>\n",
       "      <td>20.60</td>\n",
       "      <td>249.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>23.00</td>\n",
       "      <td>2023/7/6</td>\n",
       "      <td>2023/7/22</td>\n",
       "      <td>22</td>\n",
       "      <td>2.30%、0.11%</td>\n",
       "      <td>2.90%、0.04%</td>\n",
       "      <td>1.10%、1.65%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>23.00</td>\n",
       "      <td>2023/7/11</td>\n",
       "      <td>2023/7/21</td>\n",
       "      <td>11</td>\n",
       "      <td>2.30%</td>\n",
       "      <td>0.10%</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>22.00</td>\n",
       "      <td>2023/7/6</td>\n",
       "      <td>2023/7/21</td>\n",
       "      <td>21</td>\n",
       "      <td>2.20%、0.10%</td>\n",
       "      <td>0.28%、0.05%</td>\n",
       "      <td>0.20%、0.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>23.00</td>\n",
       "      <td>2023/7/3</td>\n",
       "      <td>2023/7/20</td>\n",
       "      <td>20</td>\n",
       "      <td>2.30%</td>\n",
       "      <td>2.90%</td>\n",
       "      <td>1.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>技术有限公司</td>\n",
       "      <td>222.00</td>\n",
       "      <td>2023/7/4</td>\n",
       "      <td>2023/12/30</td>\n",
       "      <td>31</td>\n",
       "      <td>22.20%</td>\n",
       "      <td>15.39%</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>香港8899</td>\n",
       "      <td>120.00</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2023/8/31</td>\n",
       "      <td>15</td>\n",
       "      <td>12.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>2.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>香港8899</td>\n",
       "      <td>120.00</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2024/8/31</td>\n",
       "      <td>31</td>\n",
       "      <td>12.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>2.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>香港8899</td>\n",
       "      <td>100.00</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/12/31</td>\n",
       "      <td>31</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>1.00%</td>\n",
       "      <td>1.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>300.00</td>\n",
       "      <td>2023/7/17</td>\n",
       "      <td>2023/11/22</td>\n",
       "      <td>15</td>\n",
       "      <td>30.00%</td>\n",
       "      <td>1.25%</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>566.00</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/1/1</td>\n",
       "      <td>14</td>\n",
       "      <td>56.60%、22.20%</td>\n",
       "      <td>5.00%、5.00%</td>\n",
       "      <td>5.00%、1.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>222.00</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/7/18</td>\n",
       "      <td>14</td>\n",
       "      <td>22.20%</td>\n",
       "      <td>6.89%</td>\n",
       "      <td>0.50%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>取暖费企业1</td>\n",
       "      <td>444.00</td>\n",
       "      <td>2023/7/18</td>\n",
       "      <td>2024/7/4</td>\n",
       "      <td>14</td>\n",
       "      <td>44.40%</td>\n",
       "      <td>0.64%</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>mo-企业对账名称-1</td>\n",
       "      <td>22.00</td>\n",
       "      <td>2023/7/7</td>\n",
       "      <td>2023/8/16</td>\n",
       "      <td>31</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>0.29%</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>前途有限公司</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/7/7</td>\n",
       "      <td>7</td>\n",
       "      <td>0.10%</td>\n",
       "      <td>0.14%</td>\n",
       "      <td>1.10%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>前途有限公司</td>\n",
       "      <td>12.00</td>\n",
       "      <td>2023/7/1</td>\n",
       "      <td>2023/10/27</td>\n",
       "      <td>31</td>\n",
       "      <td>1.20%</td>\n",
       "      <td>0.41%</td>\n",
       "      <td>11.30%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>合并测试企业1</td>\n",
       "      <td>500.00</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/19</td>\n",
       "      <td>13</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>15.00%</td>\n",
       "      <td>5.50%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>合并测试企业1</td>\n",
       "      <td>100.00</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2024/7/19</td>\n",
       "      <td>13</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>0.28%</td>\n",
       "      <td>3.30%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>跨年企业1</td>\n",
       "      <td>333.00</td>\n",
       "      <td>2023/7/19</td>\n",
       "      <td>2025/12/31</td>\n",
       "      <td>897</td>\n",
       "      <td>33.30%</td>\n",
       "      <td>6.94%</td>\n",
       "      <td>5.60%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>跨年企业2</td>\n",
       "      <td>222.00</td>\n",
       "      <td>2023/7/20</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>31</td>\n",
       "      <td>22.20%、6.66%</td>\n",
       "      <td>5.55%、10.44%</td>\n",
       "      <td>55.50%、5.55%</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           企业名称  租赁面积/㎡       开始日期        截止日期  租赁天数  \\\n",
       "0   wy企业1333345    8.00   2023/5/1    2023/7/1     1   \n",
       "1         wy企业3    1.00  2023/7/17   2024/7/31    15   \n",
       "2         wy企业3    1.00  2023/7/17   2024/7/31    15   \n",
       "3         wy企业3    1.00  2023/7/19    2024/7/1    13   \n",
       "4         wy企业4    1.00  2023/7/18    2024/8/1    14   \n",
       "5         wy企业9  135.52   2023/7/1   2023/8/31    31   \n",
       "6        wy企业10    1.00  2023/7/11   2024/7/31    21   \n",
       "7        技术有限公司   23.00   2023/7/6   2023/7/22    22   \n",
       "8        技术有限公司   23.00  2023/7/11   2023/7/21    11   \n",
       "9        技术有限公司   22.00   2023/7/6   2023/7/21    21   \n",
       "10       技术有限公司   23.00   2023/7/3   2023/7/20    20   \n",
       "11       技术有限公司  222.00   2023/7/4  2023/12/30    31   \n",
       "12       香港8899  120.00  2023/7/17   2023/8/31    15   \n",
       "13       香港8899  120.00   2023/7/1   2024/8/31    31   \n",
       "14       香港8899  100.00   2023/7/1  2023/12/31    31   \n",
       "15       取暖费企业1  300.00  2023/7/17  2023/11/22    15   \n",
       "16       取暖费企业1  566.00  2023/7/18    2024/1/1    14   \n",
       "17       取暖费企业1  222.00  2023/7/18   2024/7/18    14   \n",
       "18       取暖费企业1  444.00  2023/7/18    2024/7/4    14   \n",
       "19  mo-企业对账名称-1   22.00   2023/7/7   2023/8/16    31   \n",
       "20       前途有限公司    1.00   2023/7/1    2023/7/7     7   \n",
       "21       前途有限公司   12.00   2023/7/1  2023/10/27    31   \n",
       "22      合并测试企业1  500.00  2023/7/19   2024/7/19    13   \n",
       "23      合并测试企业1  100.00  2023/7/19   2024/7/19    13   \n",
       "24        跨年企业1  333.00  2023/7/19  2025/12/31   897   \n",
       "25        跨年企业2  222.00  2023/7/20    2024/8/1    31   \n",
       "\n",
       "                        总【占比】                 办公用房【占比】  \\\n",
       "0          0.80%、21.60%、2.16%        0.10%、2.55%、1.02%   \n",
       "1             100.00%、100.00%          100.00%、100.00%   \n",
       "2             100.00%、100.00%          100.00%、100.00%   \n",
       "3             100.00%、100.00%          100.00%、100.00%   \n",
       "4               0.13%、100.00%            0.13%、100.00%   \n",
       "5                      20.00%                    1.25%   \n",
       "6   100.00%、6100.00%、7100.00%  100.00%、100.00%、100.00%   \n",
       "7                 2.30%、0.11%              2.90%、0.04%   \n",
       "8                       2.30%                    0.10%   \n",
       "9                 2.20%、0.10%              0.28%、0.05%   \n",
       "10                      2.30%                    2.90%   \n",
       "11                     22.20%                   15.39%   \n",
       "12                     12.00%                    1.25%   \n",
       "13                     12.00%                    1.25%   \n",
       "14                     10.00%                    1.00%   \n",
       "15                     30.00%                    1.25%   \n",
       "16              56.60%、22.20%              5.00%、5.00%   \n",
       "17                     22.20%                    6.89%   \n",
       "18                     44.40%                    0.64%   \n",
       "19                      2.20%                    0.29%   \n",
       "20                      0.10%                    0.14%   \n",
       "21                      1.20%                    0.41%   \n",
       "22                     50.00%                   15.00%   \n",
       "23                     10.00%                    0.28%   \n",
       "24                     33.30%                    6.94%   \n",
       "25               22.20%、6.66%             5.55%、10.44%   \n",
       "\n",
       "                   测试机房【占比】  办公【电费】【含税】  测试机房【电费】【含税】  【水费】【含税】  餐厅【燃气费】【含税】  \\\n",
       "0       1.80%、62.30%、31.15%           0           0.0      0.00          0.0   \n",
       "1           100.00%、100.00%           0           0.0    178.26          0.0   \n",
       "2           100.00%、100.00%           0           0.0      0.00          0.0   \n",
       "3           100.00%、100.00%           0           0.0      0.00          0.0   \n",
       "4             0.13%、100.00%           0           0.0     83.19          0.0   \n",
       "5                    10.00%           0           0.0      0.00          0.0   \n",
       "6   100.00%、100.00%、100.00%           0           0.0    249.58          0.0   \n",
       "7               1.10%、1.65%           0           0.0      0.00          0.0   \n",
       "8                     0.20%           0           0.0      0.00          0.0   \n",
       "9               0.20%、0.10%           0           0.0      0.00          0.0   \n",
       "10                    1.10%           0           0.0      0.00          0.0   \n",
       "11                    2.20%           0           0.0      0.00          0.0   \n",
       "12                    2.00%           0           0.0      0.00          0.0   \n",
       "13                    2.00%           0           0.0      0.00          0.0   \n",
       "14                    1.00%           0           0.0      0.00          0.0   \n",
       "15                   50.00%           0           0.0      0.00          0.0   \n",
       "16              5.00%、1.10%           0           0.0      0.00          0.0   \n",
       "17                    0.50%           0           0.0      0.00          0.0   \n",
       "18                    0.20%           0           0.0      0.00          0.0   \n",
       "19                    2.20%           0           0.0      0.00          0.0   \n",
       "20                    1.10%           0           0.0      0.00          0.0   \n",
       "21                   11.30%           0           0.0      0.00          0.0   \n",
       "22                    5.50%           0           0.0      0.00          0.0   \n",
       "23                    3.30%           0           0.0      0.00          0.0   \n",
       "24                    5.60%           0           0.0      0.00          0.0   \n",
       "25             55.50%、5.55%           0           0.0      0.00          0.0   \n",
       "\n",
       "    单位不含税合计  单位税金合计  单位含税合计  \n",
       "0      0.00    0.00    0.00  \n",
       "1    524.02   54.24  578.26  \n",
       "2      0.00    0.00    0.00  \n",
       "3      0.00    0.00    0.00  \n",
       "4     76.32    6.87   83.19  \n",
       "5      0.00    0.00    0.00  \n",
       "6    228.96   20.60  249.58  \n",
       "7      0.00    0.00    0.00  \n",
       "8      0.00    0.00    0.00  \n",
       "9      0.00    0.00    0.00  \n",
       "10     0.00    0.00    0.00  \n",
       "11     0.00    0.00    0.00  \n",
       "12     0.00    0.00    0.00  \n",
       "13     0.00    0.00    0.00  \n",
       "14     0.00    0.00    0.00  \n",
       "15     0.00    0.00    0.00  \n",
       "16     0.00    0.00    0.00  \n",
       "17     0.00    0.00    0.00  \n",
       "18     0.00    0.00    0.00  \n",
       "19     0.00    0.00    0.00  \n",
       "20     0.00    0.00    0.00  \n",
       "21     0.00    0.00    0.00  \n",
       "22     0.00    0.00    0.00  \n",
       "23     0.00    0.00    0.00  \n",
       "24     0.00    0.00    0.00  \n",
       "25     0.00    0.00    0.00  "
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simple"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
